[ https://issues.apache.org/jira/browse/HIVE-12971?focusedWorklogId=280846&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-280846 ]
ASF GitHub Bot logged work on HIVE-12971: ----------------------------------------- Author: ASF GitHub Bot Created on: 23/Jul/19 06:56 Start Date: 23/Jul/19 06:56 Worklog Time Spent: 10m Work Description: jcamachor commented on pull request #733: HIVE-12971: Add Support for Kudu Tables URL: https://github.com/apache/hive/pull/733#discussion_r306153053 ########## File path: kudu-handler/src/test/queries/positive/kudu_queries.q ########## @@ -0,0 +1,148 @@ +--! qt:dataset:src + +-- Create table specifying columns. +-- Note: Kudu is the source of truth for schema. +DROP TABLE IF EXISTS kv_table; +CREATE EXTERNAL TABLE kv_table(key int, value string) +STORED BY 'org.apache.hadoop.hive.kudu.KuduStorageHandler' +TBLPROPERTIES ("kudu.table_name" = "default.kudu_kv"); + +DESCRIBE EXTENDED kv_table; + +-- Verify INSERT support. +INSERT INTO TABLE kv_table VALUES +(1, "1"), (2, "2"); + +SELECT * FROM kv_table; +SELECT count(*) FROM kv_table; +SELECT count(*) FROM kv_table LIMIT 1; +SELECT count(1) FROM kv_table; + +-- Verify projection and case insensitivity. +SELECT kEy FROM kv_table; + +DROP TABLE kv_table; + +-- Create table without specifying columns. +-- Note: Kudu is the source of truth for schema. +DROP TABLE IF EXISTS all_types_table; +CREATE EXTERNAL TABLE all_types_table +STORED BY 'org.apache.hadoop.hive.kudu.KuduStorageHandler' +TBLPROPERTIES ("kudu.table_name" = "default.kudu_all_types"); + +DESCRIBE EXTENDED all_types_table; + +INSERT INTO TABLE all_types_table VALUES +(1, 1, 1, 1, true, 1.1, 1.1, "one", 'one', '2011-11-11 11:11:11', 1.111, null, 1), +(2, 2, 2, 2, false, 2.2, 2.2, "two", 'two', '2012-12-12 12:12:12', 2.222, null, 2); + +SELECT * FROM all_types_table; +SELECT count(*) FROM all_types_table; + +-- Verify comparison predicates on byte. +SELECT key FROM all_types_table WHERE key = 1; Review comment: In addition to `SELECT...` queries, add a few `EXPLAIN SELECT...` plans to q file so we can verify that computation is being pushed to Kudu as expected, etc. ---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org Issue Time Tracking ------------------- Worklog Id: (was: 280846) Time Spent: 2h 10m (was: 2h) > Hive Support for Kudu > --------------------- > > Key: HIVE-12971 > URL: https://issues.apache.org/jira/browse/HIVE-12971 > Project: Hive > Issue Type: New Feature > Affects Versions: 2.0.0 > Reporter: Lenni Kuff > Assignee: Grant Henke > Priority: Major > Labels: pull-request-available > Attachments: HIVE-12971.0.patch, HIVE-12971.1.patch, > HIVE-12971.2.patch, HIVE-12971.3.patch > > Time Spent: 2h 10m > Remaining Estimate: 0h > > JIRA for tracking work related to Hive/Kudu integration. > It would be useful to allow Kudu data to be accessible via Hive. This would > involve creating a Kudu SerDe/StorageHandler and implementing support for > QUERY and DML commands like SELECT, INSERT, UPDATE, and DELETE. Kudu > Input/OutputFormats classes already exist. The work can be staged to support > this functionality incrementally. -- This message was sent by Atlassian JIRA (v7.6.14#76016)