[
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)
