[jira] Updated: (HIVE-1501) when generating reentrant INSERT for index rebuild, quote identifiers using backticks
[ https://issues.apache.org/jira/browse/HIVE-1501?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Skye Berghel updated HIVE-1501: --- Attachment: 1501_with_tests.patch Adding a patch for 1501 that also includes tests. when generating reentrant INSERT for index rebuild, quote identifiers using backticks - Key: HIVE-1501 URL: https://issues.apache.org/jira/browse/HIVE-1501 Project: Hive Issue Type: Bug Components: Indexing Affects Versions: 0.7.0 Reporter: John Sichi Assignee: Skye Berghel Fix For: 0.7.0 Attachments: 1501.patch, 1501_with_tests.patch Yongqiang, you mentioned that you weren't able to do this due to SORT BY not accepting them. The SORT BY is gone now as of HIVE-1494 (and SORT BY needs to be fixed anyway). -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
[jira] Updated: (HIVE-1497) support COMMENT clause on CREATE INDEX, and add new commands for SHOW/DESCRIBE indexes
[ https://issues.apache.org/jira/browse/HIVE-1497?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Russell Melick updated HIVE-1497: - Attachment: hive-1497.p3.patch Coding complete, but unit tests not added yet. Does not deal with partitions either. support COMMENT clause on CREATE INDEX, and add new commands for SHOW/DESCRIBE indexes -- Key: HIVE-1497 URL: https://issues.apache.org/jira/browse/HIVE-1497 Project: Hive Issue Type: Improvement Components: Indexing Affects Versions: 0.7.0 Reporter: John Sichi Assignee: Russell Melick Fix For: 0.7.0 Attachments: hive-1497.p1.patch, hive-1497.p2.patch, hive-1497.p3.patch We need to work out the syntax for SHOW/DESCRIBE, taking partitioning into account. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
[jira] Commented: (HIVE-1753) HIVE 1633 hit for Stage2 jobs with CombineHiveInputFormat
[ https://issues.apache.org/jira/browse/HIVE-1753?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12925317#action_12925317 ] Sreekanth Ramakrishnan commented on HIVE-1753: -- Hi, can a commiter add me to contributor list so can I can assign issues which I am working on? HIVE 1633 hit for Stage2 jobs with CombineHiveInputFormat - Key: HIVE-1753 URL: https://issues.apache.org/jira/browse/HIVE-1753 Project: Hive Issue Type: Bug Affects Versions: 0.7.0 Reporter: Thiruvel Thirumoolan Assignee: Thiruvel Thirumoolan Fix For: 0.7.0 Attachments: HIVE-1753.patch Errors are the same as HIVE-1633 but I see them for Stage-2 jobs. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
[jira] Updated: (HIVE-474) Support for distinct selection on two or more columns
[ https://issues.apache.org/jira/browse/HIVE-474?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Namit Jain updated HIVE-474: Resolution: Fixed Fix Version/s: 0.7.0 Hadoop Flags: [Reviewed] Status: Resolved (was: Patch Available) Committed. Thanks Amareshwari Support for distinct selection on two or more columns - Key: HIVE-474 URL: https://issues.apache.org/jira/browse/HIVE-474 Project: Hive Issue Type: Improvement Components: Query Processor Reporter: Alexis Rondeau Assignee: Amareshwari Sriramadasu Fix For: 0.7.0 Attachments: hive-474.0.4.2rc.patch, patch-474-1.txt, patch-474-2.txt, patch-474-3.txt, patch-474.txt The ability to select distinct several, individual columns as by example: select count(distinct user), count(distinct session) from actions; Currently returns the following failure: FAILED: Error in semantic analysis: line 2:7 DISTINCT on Different Columns not Supported user -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
[jira] Commented: (HIVE-1498) support IDXPROPERTIES on CREATE INDEX
[ https://issues.apache.org/jira/browse/HIVE-1498?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12925529#action_12925529 ] John Sichi commented on HIVE-1498: -- +1. Will commit when tests pass. support IDXPROPERTIES on CREATE INDEX - Key: HIVE-1498 URL: https://issues.apache.org/jira/browse/HIVE-1498 Project: Hive Issue Type: Improvement Components: Indexing Affects Versions: 0.7.0 Reporter: John Sichi Assignee: Marquis Wang Fix For: 0.7.0 Attachments: 1498.2.patch, 1498.patch, hive-1498.prelim.patch It's partially there in the grammar but not hooked in; should work pretty much the same as TBLPROPERTIES. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
[jira] Commented: (HIVE-1753) HIVE 1633 hit for Stage2 jobs with CombineHiveInputFormat
[ https://issues.apache.org/jira/browse/HIVE-1753?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12925538#action_12925538 ] He Yongqiang commented on HIVE-1753: running test. HIVE 1633 hit for Stage2 jobs with CombineHiveInputFormat - Key: HIVE-1753 URL: https://issues.apache.org/jira/browse/HIVE-1753 Project: Hive Issue Type: Bug Affects Versions: 0.7.0 Reporter: Thiruvel Thirumoolan Assignee: Sreekanth Ramakrishnan Fix For: 0.7.0 Attachments: HIVE-1753.patch Errors are the same as HIVE-1633 but I see them for Stage-2 jobs. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
test output just keeps getting noisier...
JVS ... [junit] rmr: cannot remove pfile:/data/users/jsichi/open/commit-trunk/build/ql/test/data/warehouse/clustergroupby/ds=103: No such file or directory. [junit] diff -a -I file: -I pfile: -I hdfs: -I /tmp/ -I invalidscheme: -I lastUpdateTime -I lastAccessTime -I [Oo]wner -I CreateTime -I LastAccessTime -I Location -I transient_lastDdlTime -I last_modified_ -I java.lang.RuntimeException -I at org -I at sun -I at java -I at junit -I Caused by: -I [.][.][.] [0-9]* more /data/users/jsichi/open/commit-trunk/build/ql/test/logs/clientpositive/bucket_groupby.q.out /data/users/jsichi/open/commit-trunk/ql/src/test/results/clientpositive/bucket_groupby.q.out [junit] Done query: bucket_groupby.q [junit] Begin query: bucketmapjoin1.q [junit] Upload 1 JDBM File to: file:/tmp/jsichi/hive_2010-10-27_13-25-50_233_1471536439352402066/-local-10003/JDBM-Stage-1/-1-srcbucket20.txt.jdbm [junit] Upload 1 JDBM File to: file:/tmp/jsichi/hive_2010-10-27_13-25-50_233_1471536439352402066/-local-10003/JDBM-Stage-1/-1-srcbucket21.txt.jdbm [junit] Reloading existing hashtable... [junit] Reloading existing hashtable... [junit] Deleted file:/data/users/jsichi/open/commit-trunk/build/ql/test/data/warehouse/bucketmapjoin_tmp_result [junit] Deleted file:/data/users/jsichi/open/commit-trunk/build/ql/test/data/warehouse/bucketmapjoin_hash_result_1 [junit] Upload 1 JDBM File to: file:/tmp/jsichi/hive_2010-10-27_13-26-12_690_3816402881235870624/-local-10003/JDBM-Stage-1/-1--.jdbm [junit] Reloading existing hashtable... [junit] Reloading existing hashtable... [junit] Deleted file:/data/users/jsichi/open/commit-trunk/build/ql/test/data/warehouse/bucket
[jira] Created: (HIVE-1755) JDBM diff in test caused by Hive-1641
JDBM diff in test caused by Hive-1641 - Key: HIVE-1755 URL: https://issues.apache.org/jira/browse/HIVE-1755 Project: Hive Issue Type: Test Reporter: He Yongqiang Assignee: He Yongqiang -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
[jira] Updated: (HIVE-1755) JDBM diff in test caused by Hive-1641
[ https://issues.apache.org/jira/browse/HIVE-1755?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] He Yongqiang updated HIVE-1755: --- Attachment: HIVE-1755.1.patch JDBM diff in test caused by Hive-1641 - Key: HIVE-1755 URL: https://issues.apache.org/jira/browse/HIVE-1755 Project: Hive Issue Type: Test Reporter: He Yongqiang Assignee: He Yongqiang Attachments: HIVE-1755.1.patch -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
[jira] Updated: (HIVE-1755) JDBM diff in test caused by Hive-1641
[ https://issues.apache.org/jira/browse/HIVE-1755?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] He Yongqiang updated HIVE-1755: --- Status: Patch Available (was: Open) JDBM diff in test caused by Hive-1641 - Key: HIVE-1755 URL: https://issues.apache.org/jira/browse/HIVE-1755 Project: Hive Issue Type: Test Reporter: He Yongqiang Assignee: He Yongqiang Attachments: HIVE-1755.1.patch -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
[jira] Commented: (HIVE-1501) when generating reentrant INSERT for index rebuild, quote identifiers using backticks
[ https://issues.apache.org/jira/browse/HIVE-1501?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12925618#action_12925618 ] He Yongqiang commented on HIVE-1501: String indexCols = MetaStoreUtils.getColumnNamesFromFieldSchema(indexField); indexCols is a column list, like: col1, col2,col3 After the change, it should be `col1`, `col2`, `col3`... So the whole command should be like: INSERT OVERWRITE TABLE `table_name` PARTITION (...) SELECT `col1`, `col2`, `col3`..., `INPUT__FILE__NAME`, collect_set (`BLOCK__OFFSET__INSIDE__FILE`) FROM `base_table` ... GROUP BY `col1`, `col2`, `col3`..., `INPUT__FILE__NAME` when generating reentrant INSERT for index rebuild, quote identifiers using backticks - Key: HIVE-1501 URL: https://issues.apache.org/jira/browse/HIVE-1501 Project: Hive Issue Type: Bug Components: Indexing Affects Versions: 0.7.0 Reporter: John Sichi Assignee: Skye Berghel Fix For: 0.7.0 Attachments: 1501.patch, 1501_with_tests.patch Yongqiang, you mentioned that you weren't able to do this due to SORT BY not accepting them. The SORT BY is gone now as of HIVE-1494 (and SORT BY needs to be fixed anyway). -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
[jira] Commented: (HIVE-1755) JDBM diff in test caused by Hive-1641
[ https://issues.apache.org/jira/browse/HIVE-1755?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12925627#action_12925627 ] Namit Jain commented on HIVE-1755: -- +1 JDBM diff in test caused by Hive-1641 - Key: HIVE-1755 URL: https://issues.apache.org/jira/browse/HIVE-1755 Project: Hive Issue Type: Test Reporter: He Yongqiang Assignee: He Yongqiang Attachments: HIVE-1755.1.patch -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
[jira] Commented: (HIVE-1756) failures in fatal.q in TestNegativeCliDriver
[ https://issues.apache.org/jira/browse/HIVE-1756?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12925636#action_12925636 ] Namit Jain commented on HIVE-1756: -- Just remove the testcase for now failures in fatal.q in TestNegativeCliDriver Key: HIVE-1756 URL: https://issues.apache.org/jira/browse/HIVE-1756 Project: Hive Issue Type: Bug Components: Query Processor Reporter: Namit Jain Assignee: Liyin Tang This is probably caused by HIVE-1641 -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
[jira] Updated: (HIVE-1757) test cleanup for Hive-1641
[ https://issues.apache.org/jira/browse/HIVE-1757?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Liyin Tang updated HIVE-1757: - Attachment: Hive-1757.patch Remove some unnecessary print out statements test cleanup for Hive-1641 -- Key: HIVE-1757 URL: https://issues.apache.org/jira/browse/HIVE-1757 Project: Hive Issue Type: Improvement Reporter: He Yongqiang Assignee: Liyin Tang Attachments: Hive-1757.patch -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
[jira] Updated: (HIVE-1755) JDBM diff in test caused by Hive-1641
[ https://issues.apache.org/jira/browse/HIVE-1755?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Namit Jain updated HIVE-1755: - Resolution: Fixed Fix Version/s: 0.7.0 Status: Resolved (was: Patch Available) Committed. Thanks Yongqiang JDBM diff in test caused by Hive-1641 - Key: HIVE-1755 URL: https://issues.apache.org/jira/browse/HIVE-1755 Project: Hive Issue Type: Test Reporter: He Yongqiang Assignee: He Yongqiang Fix For: 0.7.0 Attachments: HIVE-1755.1.patch -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
[jira] Commented: (HIVE-1757) test cleanup for Hive-1641
[ https://issues.apache.org/jira/browse/HIVE-1757?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12925688#action_12925688 ] Namit Jain commented on HIVE-1757: -- +1 test cleanup for Hive-1641 -- Key: HIVE-1757 URL: https://issues.apache.org/jira/browse/HIVE-1757 Project: Hive Issue Type: Improvement Reporter: He Yongqiang Assignee: Liyin Tang Attachments: Hive-1757.patch -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
[jira] Resolved: (HIVE-1757) test cleanup for Hive-1641
[ https://issues.apache.org/jira/browse/HIVE-1757?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Namit Jain resolved HIVE-1757. -- Resolution: Fixed Fix Version/s: 0.7.0 Hadoop Flags: [Reviewed] Committed. Thanks Liyin test cleanup for Hive-1641 -- Key: HIVE-1757 URL: https://issues.apache.org/jira/browse/HIVE-1757 Project: Hive Issue Type: Improvement Reporter: He Yongqiang Assignee: Liyin Tang Fix For: 0.7.0 Attachments: Hive-1757.patch -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.