You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@kylin.apache.org by 林豪（linhao）-技术产品中心 <li...@qiyi.com> on 2017/06/20 02:14:39 UTC
Can Kylin execute sql and fetch result in command line?
Hi，
Recently we encounter a requirement: Execute kylin sql in command line and fetch result like hive shell:
$ kylin-shell –q “some sql” –f outfile
Is this already implemented or is there some workaround to execute sql and fetch result in command line?
林豪
云平台 研发工程师
爱奇艺公司
QIYI.com, Inc.
[sers\a\Desktop\常有人问我要的东西T T\爱奇艺联合Logo-02.png]<http://www.iqiyi.com/>
Re: Can Kylin execute sql and fetch result in command line?
Posted by Billy Liu <bi...@apache.org>.
Thanks for updating us.
2017-06-20 14:09 GMT+08:00 林豪（linhao）-技术产品中心 <li...@qiyi.com>:
> Yes, I have tried SQLLine and it is the tool I wanted.
>
>
>
> *From: *林豪（linhao）-技术产品中心 <li...@qiyi.com>
> *Reply-To: *"user@kylin.apache.org" <us...@kylin.apache.org>
> *Date: *Tuesday, 20 June 2017 at 1:14 PM
> *To: *"user@kylin.apache.org" <us...@kylin.apache.org>
> *Subject: *Re: Can Kylin execute sql and fetch result in command line?
>
>
>
> Thanks. I will try it.
>
>
>
> *From: *Billy Liu <bi...@apache.org>
> *Reply-To: *"user@kylin.apache.org" <us...@kylin.apache.org>
> *Date: *Tuesday, 20 June 2017 at 10:57 AM
> *To: *user <us...@kylin.apache.org>
> *Subject: *Re: Can Kylin execute sql and fetch result in command line?
>
>
>
> Maybe you could try SQLLine https://github.com/julianhyde/sqlline with
> Kylin JDBC Driver.
>
>
>
> 2017-06-20 10:14 GMT+08:00 林豪（linhao）-技术产品中心 <li...@qiyi.com>:
>
> Hi，
>
>
>
> Recently we encounter a requirement: Execute kylin sql in command line and
> fetch result like hive shell:
>
>
>
> $ kylin-shell –q “some sql” –f outfile
>
>
>
> Is this already implemented or is there some workaround to execute sql and
> fetch result in command line?
>
>
>
> *林豪*
>
> 云平台 研发工程师
>
>
>
> 爱奇艺公司
>
> QIYI.com, Inc.
>
> [image: rs\a\Desktop\常有人问我要的东西T T\爱奇艺联合Logo-02.png]
> <http://www.iqiyi.com/>
>
>
>
Re: Can Kylin execute sql and fetch result in command line?
Posted by 林豪（linhao）-技术产品中心 <li...@qiyi.com>.
Yes, I have tried SQLLine and it is the tool I wanted.
From: 林豪（linhao）-技术产品中心 <li...@qiyi.com>
Reply-To: "user@kylin.apache.org" <us...@kylin.apache.org>
Date: Tuesday, 20 June 2017 at 1:14 PM
To: "user@kylin.apache.org" <us...@kylin.apache.org>
Subject: Re: Can Kylin execute sql and fetch result in command line?
Thanks. I will try it.
From: Billy Liu <bi...@apache.org>
Reply-To: "user@kylin.apache.org" <us...@kylin.apache.org>
Date: Tuesday, 20 June 2017 at 10:57 AM
To: user <us...@kylin.apache.org>
Subject: Re: Can Kylin execute sql and fetch result in command line?
Maybe you could try SQLLine https://github.com/julianhyde/sqlline with Kylin JDBC Driver.
2017-06-20 10:14 GMT+08:00 林豪（linhao）-技术产品中心 <li...@qiyi.com>>:
Hi，
Recently we encounter a requirement: Execute kylin sql in command line and fetch result like hive shell:
$ kylin-shell –q “some sql” –f outfile
Is this already implemented or is there some workaround to execute sql and fetch result in command line?
林豪
云平台 研发工程师
爱奇艺公司
QIYI.com, Inc.
[rs\a\Desktop\常有人问我要的东西T T\爱奇艺联合Logo-02.png]<http://www.iqiyi.com/>
Re: Can Kylin execute sql and fetch result in command line?
Posted by 林豪（linhao）-技术产品中心 <li...@qiyi.com>.
Thanks. I will try it.
From: Billy Liu <bi...@apache.org>
Reply-To: "user@kylin.apache.org" <us...@kylin.apache.org>
Date: Tuesday, 20 June 2017 at 10:57 AM
To: user <us...@kylin.apache.org>
Subject: Re: Can Kylin execute sql and fetch result in command line?
Maybe you could try SQLLine https://github.com/julianhyde/sqlline with Kylin JDBC Driver.
2017-06-20 10:14 GMT+08:00 林豪（linhao）-技术产品中心 <li...@qiyi.com>>:
Hi，
Recently we encounter a requirement: Execute kylin sql in command line and fetch result like hive shell:
$ kylin-shell –q “some sql” –f outfile
Is this already implemented or is there some workaround to execute sql and fetch result in command line?
林豪
云平台 研发工程师
爱奇艺公司
QIYI.com, Inc.
[ers\a\Desktop\常有人问我要的东西T T\爱奇艺联合Logo-02.png]<http://www.iqiyi.com/>
Re: Can Kylin execute sql and fetch result in command line?
Posted by Billy Liu <bi...@apache.org>.
Maybe you could try SQLLine https://github.com/julianhyde/sqlline with
Kylin JDBC Driver.
2017-06-20 10:14 GMT+08:00 林豪（linhao）-技术产品中心 <li...@qiyi.com>:
> Hi，
>
>
>
> Recently we encounter a requirement: Execute kylin sql in command line and
> fetch result like hive shell:
>
>
>
> $ kylin-shell –q “some sql” –f outfile
>
>
>
> Is this already implemented or is there some workaround to execute sql and
> fetch result in command line?
>
>
>
> *林豪*
>
> 云平台 研发工程师
>
>
>
> 爱奇艺公司
>
> QIYI.com, Inc.
>
> [image: sers\a\Desktop\常有人问我要的东西T T\爱奇艺联合Logo-02.png]
> <http://www.iqiyi.com/>
>