[jira] [Assigned] (HIVE-26229) HPLSQL

["Johnson (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-26229?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Johnson reassigned HIVE-26229:
------------------------------

    Assignee:     (was: Johnson)

> HPLSQL
> ------
>
>                 Key: HIVE-26229
>                 URL: https://issues.apache.org/jira/browse/HIVE-26229
>             Project: Hive
>          Issue Type: Bug
>          Components: hpl/sql
>         Environment: development environment, we used the HPL\SQL version of 
>  * 
> HPL/SQL 0.3.31 - September 11, 2017 which download from [http://www.hplsql.org/download]
>   I have attached all the scripts, you can reference them. If you need any support from me, please free feel to let me know, thx
>            Reporter: Johnson
>            Priority: Major
>         Attachments: DDL.sql, issue_image.jpg, landing.SP_DynamicSQL.proc
>
>
> Hello dear experts,
>           I met a block about the Dynamic SQL in hpl\sql.  It can't use this method to generate the correct string:
>           DECLARE cur_col_list CURSOR FOR 
>                 ' SELECT col_name,col_type FROM ' || v_src_tb || 
>                 ' WHERE tb_name = ' || '''' || v_tb_name || '''' ;
>          the result as below(missed single quotes on both side of {color:#ff0000}sta_wop_md_op_topic_option{color} :    
>            !issue_image.jpg!
>          but the correct result should be like this:   
>          SELECT col_name,col_type
>          FROM landing.meta
>          WHERE tb_name = {color:#ff0000}'sta_wop_md_op_topic_option'{color} ;
>        



--
This message was sent by Atlassian Jira
(v8.20.7#820007)