You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Johnson (Jira)" <ji...@apache.org> on 2022/05/17 01:51:00 UTC
[jira] [Commented] (HIVE-26229) HPLSQL
[ https://issues.apache.org/jira/browse/HIVE-26229?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17537869#comment-17537869 ]
Johnson commented on HIVE-26229:
--------------------------------
Dear Dmitry Tolpeko,
I had shown the issue to you by e-mail before , now I follow your advise to raise this bug here, if you need any support from me, please feel free to let me know, thx
> 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
> Assignee: Dmitry Tolpeko
> 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)