[jira] [Updated] (HIVE-2726) COALESCE(NULL, NULL) NPEs

[ https://issues.apache.org/jira/browse/HIVE-2726?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Phabricator updated HIVE-2726: -- Attachment: HIVE-2726.D1317.2.patch jonchang updated the revision "HIVE-2726 [jira] COALESCE(NULL, NULL)

[jira] [Updated] (HIVE-2726) COALESCE(NULL, NULL) NPEs

[ https://issues.apache.org/jira/browse/HIVE-2726?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Phabricator updated HIVE-2726: -- Attachment: HIVE-2726.D1677.1.patch jonchang requested code review of "HIVE-2726 [jira] COALESCE(NULL, N

[jira] [Commented] (HIVE-2794) Aggregations without grouping should return NULL when applied to partitioning column of a partitionless table

[ https://issues.apache.org/jira/browse/HIVE-2794?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13204295#comment-13204295 ] Carl Steinbach commented on HIVE-2794: -- "SELECT MAX(p) FROM empty" should return NULL,

[jira] [Created] (HIVE-2794) Aggregations without grouping should return NULL when applied to partitioning column of a partitionless table

Aggregations without grouping should return NULL when applied to partitioning column of a partitionless table - Key: HIVE-2794 URL: https://issues.apache.o

[jira] [Updated] (HIVE-2749) CONV returns incorrect results sometimes

[ https://issues.apache.org/jira/browse/HIVE-2749?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Namit Jain updated HIVE-2749: - Resolution: Fixed Status: Resolved (was: Patch Available) Committed. Thanks Jonathan

Showing wrong count after importing table in Hive

Hello All, I have imported near about 10 tables in Hive from MS SQL Server. But when I try to cross check the records in Hive in one of the Table I have found more record when I run the query (select count(*) from tblName;). Then I have drop the that Table and again imported it in Hive. I have

[jira] [Updated] (HIVE-2793) Disable loadpart_err.q on 0.23

[ https://issues.apache.org/jira/browse/HIVE-2793?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-2793: - Attachment: HIVE-2793.D1665.1.patch > Disable loadpart_err.q on 0.23 > ---

[jira] [Updated] (HIVE-2793) Disable loadpart_err.q on 0.23

[ https://issues.apache.org/jira/browse/HIVE-2793?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Phabricator updated HIVE-2793: -- Attachment: HIVE-2793.D1665.1.patch cwsteinbach requested code review of "HIVE-2793 [jira] Disable loadp

[jira] [Created] (HIVE-2793) Disable loadpart_err.q on 0.23

Disable loadpart_err.q on 0.23 -- Key: HIVE-2793 URL: https://issues.apache.org/jira/browse/HIVE-2793 Project: Hive Issue Type: Bug Components: Testing Infrastructure Reporter: Carl Steinbach

[jira] [Commented] (HIVE-2793) Disable loadpart_err.q on 0.23

[ https://issues.apache.org/jira/browse/HIVE-2793?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13204224#comment-13204224 ] Carl Steinbach commented on HIVE-2793: -- This testcase was previously disabled for all

Re: optimization of tree plan generated by Hive...

Hi Alexis, Work is already underway to add the YSmart optimizer to Hive. Please take a look at https://issues.apache.org/jira/browse/HIVE-2206. Thanks. Carl On Wed, Feb 8, 2012 at 6:17 PM, Alexis De La Cruz Toledo < alexis...@gmail.com> wrote: > Hi! My name is Alexis. I am a master student of

[jira] [Commented] (HIVE-2782) New BINARY type produces unexpected results with supported UDFS when using MapReduce2

[ https://issues.apache.org/jira/browse/HIVE-2782?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13204202#comment-13204202 ] Carl Steinbach commented on HIVE-2782: -- @Ashutosh: I also found what I think is a bug

[jira] [Commented] (HIVE-2792) SUBSTR(CAST( AS BINARY)) produces unexpected results

[ https://issues.apache.org/jira/browse/HIVE-2792?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13204200#comment-13204200 ] Carl Steinbach commented on HIVE-2792: -- {noformat} SELECT value, SUBSTR(value, 4,

[jira] [Created] (HIVE-2792) SUBSTR(CAST( AS BINARY)) produces unexpected results

SUBSTR(CAST( AS BINARY)) produces unexpected results Key: HIVE-2792 URL: https://issues.apache.org/jira/browse/HIVE-2792 Project: Hive Issue Type: Bug Components: UDF

Hive-trunk-h0.21 - Build # 1249 - Still Failing

Changes for Build #1207 [namit] HIVE-2718 NPE in union followed by join (He Yongqiang via namit) Changes for Build #1208 Changes for Build #1209 Changes for Build #1210 [namit] HIVE-2674 get_partitions_ps throws TApplicationException if table doesn't exist (Kevin Wilfong via namit) Changes f

[jira] [Assigned] (HIVE-2791) filter is still removed due to regression of HIVE-1538 althougth HIVE-2344

[ https://issues.apache.org/jira/browse/HIVE-2791?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Chauhan reassigned HIVE-2791: -- Assignee: binlijin Binlijin, Is it ready for review? Mark Patch Available in that case.

[jira] [Commented] (HIVE-2759) Change global_limit.q into linux format file

[ https://issues.apache.org/jira/browse/HIVE-2759?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13204174#comment-13204174 ] Hudson commented on HIVE-2759: -- Integrated in Hive-trunk-h0.21 #1249 (See [https://builds.apa

Re: Thrift build

Thanks Namit. $ svn co svn+ssh://tubbs/svnhive/hadoop/external/thrift-0.7.0 svn: To better debug SSH connection problems, remove the -q option from 'ssh' in the [tunnels] section of your Subversion configuration file. svn: Network connection closed unexpectedly I am not able to reach it. Am I mis

Re: Thrift build

Check out svn+ssh://tubbs/svnhive/hadoop/external/thrift-0.7.0 And set your thrift.home to the above On 2/8/12 12:32 PM, "Aniket Mokashi" wrote: >Hi, > >I made some changes to hive_metastore.thrift to add a few new apis. I am >trying to generate code with thrift, but I am hitting following err

[jira] [Commented] (HIVE-2782) New BINARY type produces unexpected results with supported UDFS when using MapReduce2

[ https://issues.apache.org/jira/browse/HIVE-2782?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13204109#comment-13204109 ] Zhenxiao Luo commented on HIVE-2782: @carl: No problem with the original patch. @Ashut

[jira] [Commented] (HIVE-2782) New BINARY type produces unexpected results with supported UDFS when using MapReduce2

[ https://issues.apache.org/jira/browse/HIVE-2782?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13204094#comment-13204094 ] Ashutosh Chauhan commented on HIVE-2782: {noformat} [junit] < 2 10val_10

[jira] [Commented] (HIVE-2782) New BINARY type produces unexpected results with supported UDFS when using MapReduce2

[ https://issues.apache.org/jira/browse/HIVE-2782?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13204092#comment-13204092 ] Carl Steinbach commented on HIVE-2782: -- @Zhenxiao: Can you please explain how this is

[jira] [Commented] (HIVE-2782) New BINARY type produces unexpected results with supported UDFS when using MapReduce2

[ https://issues.apache.org/jira/browse/HIVE-2782?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13204081#comment-13204081 ] Zhenxiao Luo commented on HIVE-2782: I think Carl is correct. Order by the fifth charac

[jira] [Commented] (HIVE-2372) java.io.IOException: error=7, Argument list too long

[ https://issues.apache.org/jira/browse/HIVE-2372?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13204037#comment-13204037 ] Luis Ramos commented on HIVE-2372: -- As a hive user affected by this bug, I would have no p

[jira] [Updated] (HIVE-2759) Change global_limit.q into linux format file

[ https://issues.apache.org/jira/browse/HIVE-2759?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Namit Jain updated HIVE-2759: - Resolution: Fixed Hadoop Flags: Reviewed Status: Resolved (was: Patch Available) Committe

Hive-trunk-h0.21 - Build # 1248 - Still Failing

Changes for Build #1204 [cws] HIVE-2719. Revert HIVE-2589 (He Yongqiang via cws) Changes for Build #1205 Changes for Build #1207 [namit] HIVE-2718 NPE in union followed by join (He Yongqiang via namit) Changes for Build #1208 Changes for Build #1209 Changes for Build #1210 [namit] HIVE-2674

[jira] [Updated] (HIVE-2788) When integrating into MapReduce2, Hive is unable to handle corrupt rcfile archive

[ https://issues.apache.org/jira/browse/HIVE-2788?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zhenxiao Luo updated HIVE-2788: --- Description: archive_corrupt.q is failing due to file format exception when loading archive_corrupt.r

[jira] [Commented] (HIVE-2777) ability to add and drop partitions atomically

[ https://issues.apache.org/jira/browse/HIVE-2777?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13203913#comment-13203913 ] Aniket Mokashi commented on HIVE-2777: -- I am adding deleteData option there, deletion

[jira] [Updated] (HIVE-2790) When integrating into MapReduce2, GROUP BY on Floating Point and String types are broken

[ https://issues.apache.org/jira/browse/HIVE-2790?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zhenxiao Luo updated HIVE-2790: --- Description: Query result(-30.33) is missing in the running output: [junit] Begin query: groupby_neg_

[jira] [Commented] (HIVE-2777) ability to add and drop partitions atomically

[ https://issues.apache.org/jira/browse/HIVE-2777?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13203896#comment-13203896 ] Ashutosh Chauhan commented on HIVE-2777: So, this api is purely metadata and data w

[jira] [Commented] (HIVE-2782) New BINARY type produces unexpected results with supported UDFS when using MapReduce2

[ https://issues.apache.org/jira/browse/HIVE-2782?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13203886#comment-13203886 ] Carl Steinbach commented on HIVE-2782: -- @Ashutosh: here's a slightly reformatted versi

[jira] [Commented] (HIVE-2726) COALESCE(NULL, NULL) NPEs

[ https://issues.apache.org/jira/browse/HIVE-2726?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13203850#comment-13203850 ] Namit Jain commented on HIVE-2726: -- The following tests failed: udaf_context_ngrams.q udf

[jira] [Updated] (HIVE-2726) COALESCE(NULL, NULL) NPEs

[ https://issues.apache.org/jira/browse/HIVE-2726?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Namit Jain updated HIVE-2726: - Status: Open (was: Patch Available) > COALESCE(NULL, NULL) NPEs > - > >

[jira] [Commented] (HIVE-2782) New BINARY type produces unexpected results with supported UDFS when using MapReduce2

[ https://issues.apache.org/jira/browse/HIVE-2782?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13203844#comment-13203844 ] Ashutosh Chauhan commented on HIVE-2782: You modified the original query in non-tri

[jira] [Updated] (HIVE-2771) Add support for filter pushdown for key ranges in hbase for keys of type string

[ https://issues.apache.org/jira/browse/HIVE-2771?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Phabricator updated HIVE-2771: -- Attachment: HIVE-2771.D1551.2.patch ashutoshc updated the revision "HIVE-2771 [jira] Add support for fil

[jira] [Commented] (HIVE-2771) Add support for filter pushdown for key ranges in hbase for keys of type string

[ https://issues.apache.org/jira/browse/HIVE-2771?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13203830#comment-13203830 ] Ashutosh Chauhan commented on HIVE-2771: It is. I plan to take that up in a follow-

[jira] [Commented] (HIVE-2771) Add support for filter pushdown for key ranges in hbase for keys of type string

[ https://issues.apache.org/jira/browse/HIVE-2771?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13203812#comment-13203812 ] John Sichi commented on HIVE-2771: -- Isn't a range predicate such as "WHERE key > 20 and ke

[jira] [Commented] (HIVE-2771) Add support for filter pushdown for key ranges in hbase for keys of type string

[ https://issues.apache.org/jira/browse/HIVE-2771?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13203786#comment-13203786 ] Phabricator commented on HIVE-2771: --- ashutoshc has commented on the revision "HIVE-2771 [

[jira] [Commented] (HIVE-2372) java.io.IOException: error=7, Argument list too long

[ https://issues.apache.org/jira/browse/HIVE-2372?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13203684#comment-13203684 ] Sergey Tryuber commented on HIVE-2372: -- That's was my initial idea (you even can see t

[jira] [Updated] (HIVE-2782) New BINARY type produces unexpected results with supported UDFS when using MapReduce2

[ https://issues.apache.org/jira/browse/HIVE-2782?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-2782: - Assignee: Carl Steinbach (was: Zhenxiao Luo) Status: Patch Available (was: Open) > New

[jira] [Updated] (HIVE-2782) New BINARY type produces unexpected results with supported UDFS when using MapReduce2

[ https://issues.apache.org/jira/browse/HIVE-2782?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-2782: - Attachment: HIVE-2782.D1653.1.patch > New BINARY type produces unexpected results with support

[jira] [Updated] (HIVE-2782) New BINARY type produces unexpected results with supported UDFS when using MapReduce2

[ https://issues.apache.org/jira/browse/HIVE-2782?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Phabricator updated HIVE-2782: -- Attachment: HIVE-2782.D1653.1.patch cwsteinbach requested code review of "HIVE-2782 [jira] New BINARY ty

[jira] [Updated] (HIVE-2789) When integrating into MapReduce2, 'select * from src distribute by src.key limit 1' returns non-deterministic result

[ https://issues.apache.org/jira/browse/HIVE-2789?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-2789: - Status: Patch Available (was: Open) > When integrating into MapReduce2, 'select * from src di

[jira] [Updated] (HIVE-2789) When integrating into MapReduce2, 'select * from src distribute by src.key limit 1' returns non-deterministic result

[ https://issues.apache.org/jira/browse/HIVE-2789?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-2789: - Attachment: HIVE-2789.D1647.1.patch > When integrating into MapReduce2, 'select * from src dis

[jira] [Updated] (HIVE-2789) When integrating into MapReduce2, 'select * from src distribute by src.key limit 1' returns non-deterministic result

[ https://issues.apache.org/jira/browse/HIVE-2789?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Phabricator updated HIVE-2789: -- Attachment: HIVE-2789.D1647.1.patch cwsteinbach requested code review of "HIVE-2789 [jira] When integrat

[jira] [Commented] (HIVE-494) Select columns by index instead of name

[ https://issues.apache.org/jira/browse/HIVE-494?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13203357#comment-13203357 ] Phabricator commented on HIVE-494: -- navis has commented on the revision "HIVE-494 [jira] Se

[jira] [Updated] (HIVE-494) Select columns by index instead of name

[ https://issues.apache.org/jira/browse/HIVE-494?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Phabricator updated HIVE-494: - Attachment: HIVE-494.D1641.1.patch navis requested code review of "HIVE-494 [jira] Select columns by index