[jira] [Commented] (HIVE-13928) Hive2: float value need to be single quoted inside where clause to return rows when it doesn't have to be

[ https://issues.apache.org/jira/browse/HIVE-13928?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15329567#comment-15329567 ] Takahiko Saito commented on HIVE-13928: --- I don't think anyone is working on it. Cc: [~mmccline]

[jira] [Updated] (HIVE-14005) Changing a string column of ORC table to boolean sets values to be 'NULL'

[ https://issues.apache.org/jira/browse/HIVE-14005?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takahiko Saito updated HIVE-14005: -- Description: {noformat} 0: jdbc:hive2://os-r7-rcmpc-nat-u-hiveserver2> 0:

[jira] [Updated] (HIVE-14005) Changing a string column of ORC table to boolean sets values to be 'NULL'

[ https://issues.apache.org/jira/browse/HIVE-14005?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takahiko Saito updated HIVE-14005: -- Summary: Changing a string column of ORC table to boolean sets values to be 'NULL' (was:

[jira] [Comment Edited] (HIVE-13946) Decimal value need to be single-quoted when selecting where clause with that decimal value in order to get row

[ https://issues.apache.org/jira/browse/HIVE-13946?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15327852#comment-15327852 ] Takahiko Saito edited comment on HIVE-13946 at 6/13/16 6:01 PM:

[jira] [Commented] (HIVE-13946) Decimal value need to be single-quoted when selecting where clause with that decimal value in order to get row

[ https://issues.apache.org/jira/browse/HIVE-13946?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15327852#comment-15327852 ] Takahiko Saito commented on HIVE-13946: --- [~sircodesalot] I believe you are testing with Hive2 and

[jira] [Updated] (HIVE-13943) Null is inserted into an existing partition after replacing a column of int with string group type of text formatted partitioned table

[ https://issues.apache.org/jira/browse/HIVE-13943?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takahiko Saito updated HIVE-13943: -- Description: Create a text formatted table with a int column partitioned by a string column.

[jira] [Updated] (HIVE-13943) Null is inserted into an existing partition after replacing a column of int with string group type of text formatted partitioned table

[ https://issues.apache.org/jira/browse/HIVE-13943?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takahiko Saito updated HIVE-13943: -- Summary: Null is inserted into an existing partition after replacing a column of int with

[jira] [Updated] (HIVE-13943) Null is inserted into an existing partition after replacing a column of int with string of text formatted partitioned table

[ https://issues.apache.org/jira/browse/HIVE-13943?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takahiko Saito updated HIVE-13943: -- Description: Create a text formatted table with a int column partitioned by a string column.

[jira] [Commented] (HIVE-13935) Changing char column of textfile table to string/varchar leaves white space.

[ https://issues.apache.org/jira/browse/HIVE-13935?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15314469#comment-15314469 ] Takahiko Saito commented on HIVE-13935: --- Thanks for your explanation. I have a follow-up question.

[jira] [Commented] (HIVE-13935) Changing char column of textfile table to string/varchar leaves white space.

[ https://issues.apache.org/jira/browse/HIVE-13935?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15313423#comment-15313423 ] Takahiko Saito commented on HIVE-13935: --- Thanks for the suggestion, [~gopalv] Yes, HDFS contains

[jira] [Updated] (HIVE-13935) Changing char column of textfile table to string/varchar leaves white space.

[ https://issues.apache.org/jira/browse/HIVE-13935?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takahiko Saito updated HIVE-13935: -- Summary: Changing char column of textfile table to string/varchar leaves white space. (was:

[jira] [Updated] (HIVE-13851) Change column of textfile formatted table from float to double will drop some fractional digits

[ https://issues.apache.org/jira/browse/HIVE-13851?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takahiko Saito updated HIVE-13851: -- Summary: Change column of textfile formatted table from float to double will drop some

[jira] [Updated] (HIVE-13812) Changing column from float to string group type will drop some factional digits

[ https://issues.apache.org/jira/browse/HIVE-13812?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takahiko Saito updated HIVE-13812: -- Summary: Changing column from float to string group type will drop some factional digits (was:

[jira] [Resolved] (HIVE-13777) NPE is thrown when select table after change column from string to decimal

[ https://issues.apache.org/jira/browse/HIVE-13777?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takahiko Saito resolved HIVE-13777. --- Resolution: Cannot Reproduce The issue was not reproduced with later code. > NPE is thrown

[jira] [Updated] (HIVE-13777) NPE is thrown when select table after change column from string to decimal

[ https://issues.apache.org/jira/browse/HIVE-13777?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takahiko Saito updated HIVE-13777: -- Target Version/s: 2.1.0 (was: 1.2.1, 2.1.0) > NPE is thrown when select table after change

[jira] [Commented] (HIVE-12810) Hive select fails - java.lang.IndexOutOfBoundsException

[ https://issues.apache.org/jira/browse/HIVE-12810?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15096700#comment-15096700 ] Takahiko Saito commented on HIVE-12810: --- If you have hive.server2.enable.doAs=false, you can set it

[jira] [Updated] (HIVE-12778) Having with count distinct doesn't work for special combination

[ https://issues.apache.org/jira/browse/HIVE-12778?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takahiko Saito updated HIVE-12778: -- Affects Version/s: 1.2.1 > Having with count distinct doesn't work for special combination >

[jira] [Commented] (HIVE-12778) Having with count distinct doesn't work for special combination

[ https://issues.apache.org/jira/browse/HIVE-12778?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15095390#comment-15095390 ] Takahiko Saito commented on HIVE-12778: --- I was able to reproduce with ver. 1.2.1 with the below

[jira] [Commented] (HIVE-12810) Hive select fails - java.lang.IndexOutOfBoundsException

[ https://issues.apache.org/jira/browse/HIVE-12810?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15095298#comment-15095298 ] Takahiko Saito commented on HIVE-12810: --- [~maske], Have you checked the hiveserver2 log to see if

[jira] [Resolved] (HIVE-11870) When exporting an external table, importing it, and dropping it, hdfs data is not removed.

[ https://issues.apache.org/jira/browse/HIVE-11870?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takahiko Saito resolved HIVE-11870. --- Resolution: Won't Fix This was expected because table property for external table is true. >

[jira] [Updated] (HIVE-12435) SELECT COUNT(CASE WHEN...) GROUPBY returns 1 for 'NULL' in a case of ORC and vectorization is enabled.

[ https://issues.apache.org/jira/browse/HIVE-12435?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takahiko Saito updated HIVE-12435: -- Summary: SELECT COUNT(CASE WHEN...) GROUPBY returns 1 for 'NULL' in a case of ORC and

[jira] [Updated] (HIVE-12435) SELECT COUNT(CASE WHEN...) GROUPBY returns 1 for 'NULL' in a case of ORC

[ https://issues.apache.org/jira/browse/HIVE-12435?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takahiko Saito updated HIVE-12435: -- Summary: SELECT COUNT(CASE WHEN...) GROUPBY returns 1 for 'NULL' in a case of ORC (was: SELECT

[jira] [Updated] (HIVE-12435) SELECT COUNT(CASE WHEN...) GROUPBY returns 1 for 'NULL' in a case of ORC and vectorization is enabled.

[ https://issues.apache.org/jira/browse/HIVE-12435?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takahiko Saito updated HIVE-12435: -- Description: Run the following query: {noformat} create table count_case_groupby (key string,

[jira] [Commented] (HIVE-12435) SELECT COUNT(CASE WHEN...) GROUPBY returns 1 for 'NULL' in a case of ORC and vectorization is enabled.

[ https://issues.apache.org/jira/browse/HIVE-12435?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15009292#comment-15009292 ] Takahiko Saito commented on HIVE-12435: --- Thanks for the info, [~gopalv]. That explains why the above

[jira] [Updated] (HIVE-12420) WebHCat server throws NPE when you run command with -d user.name.

[ https://issues.apache.org/jira/browse/HIVE-12420?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takahiko Saito updated HIVE-12420: -- Summary: WebHCat server throws NPE when you run command with -d user.name. (was: Uploaded

[jira] [Updated] (HIVE-11870) When exporting an external table, importing it, and dropping it, hdfs data is not removed.

[ https://issues.apache.org/jira/browse/HIVE-11870?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takahiko Saito updated HIVE-11870: -- Summary: When exporting an external table, importing it, and dropping it, hdfs data is not

[jira] [Commented] (HIVE-5854) query fails in vectorized mode on empty partitioned table

[ https://issues.apache.org/jira/browse/HIVE-5854?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14983590#comment-14983590 ] Takahiko Saito commented on HIVE-5854: -- The issue is no longer seen in hive-0.14. It might have been

[jira] [Commented] (HIVE-9050) NULL values for empty strings when joining with ORC table

[ https://issues.apache.org/jira/browse/HIVE-9050?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14983555#comment-14983555 ] Takahiko Saito commented on HIVE-9050: -- I tried with hive-0.14.0 and the issue was not reproduced,

[jira] [Updated] (HIVE-11603) IndexOutOfBoundsException thrown when accessing a union all subquery and filtering on a column which does not exist in all underlying tables

[ https://issues.apache.org/jira/browse/HIVE-11603?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takahiko Saito updated HIVE-11603: -- Affects Version/s: 0.14.0 1.2.1 > IndexOutOfBoundsException thrown when

[jira] [Commented] (HIVE-11603) IndexOutOfBoundsException thrown when accessing a union all subquery and filtering on a column which does not exist in all underlying tables

[ https://issues.apache.org/jira/browse/HIVE-11603?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14980845#comment-14980845 ] Takahiko Saito commented on HIVE-11603: --- I tried with hive ver 0.14 and 1.2 and the issue exists. I

[jira] [Commented] (HIVE-11820) export tables with size of >32MB throws "java.lang.IllegalArgumentException: Skip CRC is valid only with update options"

[ https://issues.apache.org/jira/browse/HIVE-11820?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14899955#comment-14899955 ] Takahiko Saito commented on HIVE-11820: --- Thank you, [~ashutoshc]! > export tables with size of

[jira] [Updated] (HIVE-11820) export tables with size of >32MB throws "java.lang.IllegalArgumentException: Skip CRC is valid only with update options"

[ https://issues.apache.org/jira/browse/HIVE-11820?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takahiko Saito updated HIVE-11820: -- Attachment: HIVE-11820.patch > export tables with size of >32MB throws

[jira] [Updated] (HIVE-11820) export tables with size of >32MB throws "java.lang.IllegalArgumentException: Skip CRC is valid only with update options"

[ https://issues.apache.org/jira/browse/HIVE-11820?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takahiko Saito updated HIVE-11820: -- Fix Version/s: (was: 1.2.1) > export tables with size of >32MB throws

[jira] [Updated] (HIVE-11820) export tables with size of >32MB throws "java.lang.IllegalArgumentException: Skip CRC is valid only with update options"

[ https://issues.apache.org/jira/browse/HIVE-11820?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takahiko Saito updated HIVE-11820: -- Affects Version/s: (was: 1.2.1) > export tables with size of >32MB throws

[jira] [Updated] (HIVE-11589) Invalid value such as '-1' should be checked for 'hive.txn.timeout'.

[ https://issues.apache.org/jira/browse/HIVE-11589?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takahiko Saito updated HIVE-11589: -- Description: When an user accidentally set an invalid value such as '-1' for

[jira] [Updated] (HIVE-10968) Windows: analyze json table via beeline failed throwing Class org.apache.hive.hcatalog.data.JsonSerDe not found

[ https://issues.apache.org/jira/browse/HIVE-10968?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takahiko Saito updated HIVE-10968: -- Fix Version/s: 1.2.1 Windows: analyze json table via beeline failed throwing Class

[jira] [Updated] (HIVE-10857) Accumulo storage handler fail throwing java.lang.IllegalArgumentException: Cannot determine SASL mechanism for token class: class org.apache.accumulo.core.client.security

[ https://issues.apache.org/jira/browse/HIVE-10857?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Takahiko Saito updated HIVE-10857: -- Summary: Accumulo storage handler fail throwing java.lang.IllegalArgumentException: Cannot