[jira] [Work logged] (HIVE-21453) HPL/SQL can not SELECT Date and Timestamp type value into variable
[
https://issues.apache.org/jira/browse/HIVE-21453?focusedWorklogId=446645&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-446645
]
ASF GitHub Bot logged work on HIVE-21453:
-
Author: ASF GitHub Bot
Created on: 16/Jun/20 16:51
Start Date: 16/Jun/20 16:51
Worklog Time Spent: 10m
Work Description: github-actions[bot] closed pull request #566:
URL: https://github.com/apache/hive/pull/566
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: 446645)
Time Spent: 50m (was: 40m)
> 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: 50m
> 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 ;))) )
> 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
(v8.3.4#803005)
[jira] [Work logged] (HIVE-21453) HPL/SQL can not SELECT Date and Timestamp type value into variable
[
https://issues.apache.org/jira/browse/HIVE-21453?focusedWorklogId=442922&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-442922
]
ASF GitHub Bot logged work on HIVE-21453:
-
Author: ASF GitHub Bot
Created on: 09/Jun/20 16:12
Start Date: 09/Jun/20 16:12
Worklog Time Spent: 10m
Work Description: github-actions[bot] commented on pull request #566:
URL: https://github.com/apache/hive/pull/566#issuecomment-641143853
This pull request has been automatically marked as stale because it has not
had recent activity. It will be closed if no further activity occurs.
Feel free to reach out on the d...@hive.apache.org list if the patch is in
need of reviews.
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: 442922)
Time Spent: 40m (was: 0.5h)
> 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: 40m
> 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 ;))) )
> 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
(v8.3.4#803005)
[jira] [Work logged] (HIVE-21453) HPL/SQL can not SELECT Date and Timestamp type value into variable
[
https://issues.apache.org/jira/browse/HIVE-21453?focusedWorklogId=213687&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-213687
]
ASF GitHub Bot logged work on HIVE-21453:
-
Author: ASF GitHub Bot
Created on: 15/Mar/19 10:47
Start Date: 15/Mar/19 10:47
Worklog Time Spent: 10m
Work Description: dingqiangliu 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-473240651
@rmsmani thanks for your patience, patch submitted.
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: 213687)
Time Spent: 0.5h (was: 20m)
> 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: 0.5h
> 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 ;))) )
> 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)
[jira] [Work logged] (HIVE-21453) HPL/SQL can not SELECT Date and Timestamp type value into variable
[
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 ;))) )
> 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)
[jira] [Work logged] (HIVE-21453) HPL/SQL can not SELECT Date and Timestamp type value into variable
[
https://issues.apache.org/jira/browse/HIVE-21453?focusedWorklogId=213676&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-213676
]
ASF GitHub Bot logged work on HIVE-21453:
-
Author: ASF GitHub Bot
Created on: 15/Mar/19 10:25
Start Date: 15/Mar/19 10:25
Worklog Time Spent: 10m
Work Description: dingqiangliu 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-473234237
thank you @rmsmani !
it's done, please review it.
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: 213676)
Time Spent: 10m
Remaining Estimate: 0h
> 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: 10m
> 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 ;))) )
> 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)
