[ https://issues.apache.org/jira/browse/HIVE-21453?focusedWorklogId=213682&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-213682 ]
ASF GitHub Bot logged work on HIVE-21453: ----------------------------------------- Author: ASF GitHub Bot Created on: 15/Mar/19 10:40 Start Date: 15/Mar/19 10:40 Worklog Time Spent: 10m Work Description: rmsmani commented on issue #566: HIVE-21453: HPL/SQL can not SELECT Date and Timestamp type value INTO variable URL: https://github.com/apache/hive/pull/566#issuecomment-473238518 @dingqiangliu In Jira there will be a button **Submit Patch** Once the patch is submitted, the build will get triggered automatically and the results will be published to the JIRA ticket automatically. ---------------------------------------------------------------- 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: 213682) Time Spent: 20m (was: 10m) > HPL/SQL can not SELECT Date and Timestamp type value into variable > ------------------------------------------------------------------- > > Key: HIVE-21453 > URL: https://issues.apache.org/jira/browse/HIVE-21453 > Project: Hive > Issue Type: Bug > Components: hpl/sql > Affects Versions: 3.1.1 > Environment: Centos 7.1, Hive 3.1.1 > Reporter: DingQiang Liu > Assignee: DingQiang Liu > Priority: Minor > Labels: pull-request-available > Attachments: HIVE-21453.patch > > Time Spent: 20m > Remaining Estimate: 0h > > HPL/SQL forgot Date and Timestamp types when SELECT INTO variables. for > example, current implement will set null, not correct value, to variables > for following case, select_into3.sql: > declare v_date date; > declare v_timestamp timestamp(17, 3); > select > cast('2019-02-20 12:23:45.678' as date), > cast('2019-02-20 12:23:45.678' as timestamp) > into > v_date, > v_timestamp > from src limit 1; > print 'date: ' || v_date; > print 'timestamp: ' || v_timestamp; > The result when running : bin/hplsql -f select_into3.sql --trace > Configuration file: file:/hive/conf/hplsql-site.xml > Parser tree: (program (block (stmt (declare_stmt declare (declare_stmt_item > (declare_var_item (ident v_date) (dtype date))))) (stmt (semicolon_stmt ;)) > (stmt (declare_stmt declare (declare_stmt_item (declare_var_item (ident > v_timestamp) (dtype timestamp) (dtype_len ( 17 , 3 )))))) (stmt > (semicolon_stmt ;)) (stmt (select_stmt (fullselect_stmt (fullselect_stmt_item > (subselect_stmt select (select_list (select_list_item (expr (expr_spec_func > cast ( (expr (expr_atom (string '2019-02-20 12:23:45.678'))) as (dtype date) > )))) , (select_list_item (expr (expr_spec_func cast ( (expr (expr_atom > (string '2019-02-20 12:23:45.678'))) as (dtype timestamp) ))))) (into_clause > into (ident v_date) , (ident v_timestamp)) (from_clause from > (from_table_clause (from_table_name_clause (table_name (ident src))))) > (select_options (select_options_item limit (expr (expr_atom (int_number > 1)))))))))) (stmt (semicolon_stmt ;)) (stmt (print_stmt print (expr > (expr_concat (expr_concat_item (expr_atom (string 'date: '))) || > (expr_concat_item (expr_atom (ident v_date))))))) (stmt (semicolon_stmt ;)) > (stmt (print_stmt print (expr (expr_concat (expr_concat_item (expr_atom > (string 'timestamp: '))) || (expr_concat_item (expr_atom (ident > v_timestamp))))))) (stmt (semicolon_stmt ;))) <EOF>) > Ln:1 DECLARE v_date date > Ln:2 DECLARE v_timestamp timestamp > Ln:4 SELECT > Ln:4 select > cast('2019-02-20 12:23:45.678' as date), cast('2019-02-20 12:23:45.678' as > timestamp) > from src LIMIT 1 > Open connection: jdbc:vertica://v001:5433/test (256 ms) > Starting query > Query executed successfully (55 ms) > Ln:4 SELECT completed successfully > Ln:4 SELECT INTO statement executed > Ln:4 COLUMN: ?column?, Date > Ln:4 SET v_date = null > Ln:4 COLUMN: ?column?, Timestamp > Ln:4 SET v_timestamp = null > Ln:12 PRINT > date: > Ln:13 PRINT > timestamp: -- This message was sent by Atlassian JIRA (v7.6.3#76005)