You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@kylin.apache.org by "Laura Xia (Jira)" <ji...@apache.org> on 2023/03/24 03:13:00 UTC

[jira] [Created] (KYLIN-5478) The sql statement contains Spaces

Laura Xia created KYLIN-5478:
--------------------------------

             Summary: The sql statement contains Spaces
                 Key: KYLIN-5478
                 URL: https://issues.apache.org/jira/browse/KYLIN-5478
             Project: Kylin
          Issue Type: Improvement
            Reporter: Laura Xia
         Attachments: image-2023-03-24-11-12-30-688.png

建表语句:

create TABLE FOX.table_zw(
{{LO_ORDERKEY}} BIGINT,
{{客户号}} INT comment '客户号',
{{C_城市}} string comment '城市',
{{利润}} BIGINT comment '利润',
{{运输方式}} string comment '运输方式')
ROW FORMAT DELIMITED FIELDS TERMINATED BY '|'
STORED AS TEXTFILE;

查询api:

curl --location --request POST '[http://xxx/kylin/api/query'|http://10.1.2.213:7039/kylin/api/query'] 
--header 'Content-Type: application/json;charset=utf-8' 
--header 'Authorization: Basic QURNSU46S1lMSU4=' 
--header 'Accept-Language: en' 
--header 'Accept: application/vnd.apache.kylin-v4-public+json' 
--data-raw '\{"sql": "select lo_orderkey,客户号 from FOX.LINEORDER", "project": "test_hlx"}'



--
This message was sent by Atlassian Jira
(v8.20.10#820010)