Re: Re: kylin load hive table rest is error

2017-08-13 Thread ShaoFeng Shi
Kylin Web GUI calls the same REST API; So if Kylin GUI works, you need check your script. You can open the debug mode of browser to see the detail HTTP request header/body, and then use the same in your script. 2017-08-14 11:36 GMT+08:00 apache_...@163.com : > Yes. > >

Re: Re: kylin load hive table rest is error

2017-08-13 Thread apache_...@163.com
Yes. metric.date_dim is table name in hive load is kylin project. Executing it in two environments have same error. Kylin version:2.0 red part is tomcat log: xx.xx.xx.xx - - [14/Aug/2017:11:37:58 +0800] "GET /kylin/api/cubes/validEncodings HTTP/1.1" 200 98 xx.xx.xx.xx - -

?????? The REST query request failed

2017-08-13 Thread 578300...@qq.com
Yes, I have logged a JIRA. Thank you. -- -- ??: "Billy Liu";; : 2017??8??11??(??) 6:29 ??: "dev"; : Re: The REST query request failed It seems SUM(CASE WHEN...) does not supported

Re: Re: kylin load hive table rest is error

2017-08-13 Thread apache_...@163.com
Yes. metric.date_dim is table name in hive load is kylin project. Executing it in two environments have same error. Kylin version:2.0 apache_...@163.com From: Billy Liu Date: 2017-08-13 23:35 To: dev Subject: Re: Re: kylin load hive table rest is error As the document says

[jira] [Created] (KYLIN-2787) SUM(CASE WHEN...) does not supported

2017-08-13 Thread Shendandan (JIRA)
Shendandan created KYLIN-2787: - Summary: SUM(CASE WHEN...) does not supported Key: KYLIN-2787 URL: https://issues.apache.org/jira/browse/KYLIN-2787 Project: Kylin Issue Type: Bug

Re: [VOTE] Release apache-kylin-2.1.0 (RC2)

2017-08-13 Thread Dong Li
+1 (binding) mvn test passed gpg/md5/sha1 verified Apache Maven 3.3.9 (bb52d8502b132ec0a5a3f4c09453c07478323dc5; 2015-11-11T00:41:47+08:00) Java version: 1.7.0_79, vendor: Oracle Corporation Default locale: en_US, platform encoding: UTF-8 OS name: "mac os x", version: "10.12.6", arch: "x86_64",

Re: Re: kylin load hive table rest is error

2017-08-13 Thread Billy Liu
As the document says {tables} and {project} are path parameters, so in your case, is metric.date_dim the table name, and load the project name? http://xx.xx.xx.xx:7070/kylin/api/tables/metric.date_dim/load 2017-08-13 22:28 GMT+08:00 apache_...@163.com : > it can work by

Re: Re: kylin load hive table rest is error

2017-08-13 Thread apache_...@163.com
it can work by Kylin GUI. I refer to the API document,but is not work. Load Hive Tables POST /kylin/api/tables/{tables}/{project} Request Parameters tables - required string table names you want to load from hive, separated with comma. project - required String the project which the tables will

[jira] [Created] (KYLIN-2786) Miss "org.apache.kylin.source.kafka.DateTimeParser"

2017-08-13 Thread Shaofeng SHI (JIRA)
Shaofeng SHI created KYLIN-2786: --- Summary: Miss "org.apache.kylin.source.kafka.DateTimeParser" Key: KYLIN-2786 URL: https://issues.apache.org/jira/browse/KYLIN-2786 Project: Kylin Issue Type:

[VOTE] Release apache-kylin-2.1.0 (RC2)

2017-08-13 Thread ShaoFeng Shi
Hi all, I have created a build for Apache Kylin 2.1.0, release candidate 2. Changes highlights: KYLIN-2506 - Refactor global dictionary KYLIN-2515 - Route unsupported query back to query its source directly KYLIN-2579 KYLIN-2580 - Improvement on subqueries KYLIN-2633 - Upgrade Spark to 2.1

Re: Re: kylin load hive table rest is error

2017-08-13 Thread ShaoFeng Shi
Besides, can you sync the table from Kylin GUI? If GUI doesn't work either, that should be env problem. Otherwise it would be API usage mistake. 2017-08-13 14:22 GMT+08:00 ShaoFeng Shi : > Any message in tomcat/logs/* or logs/kylin.out? > > 2017-08-13 10:21 GMT+08:00

Re: Re: kylin load hive table rest is error

2017-08-13 Thread ShaoFeng Shi
Any message in tomcat/logs/* or logs/kylin.out? 2017-08-13 10:21 GMT+08:00 apache_...@163.com : > Hi,shaofeng: > > Kylin2.0 on HDP2.5.3. > > > hive> use metric; > OK > Time taken: 0.029 seconds > hive> show tables; > OK > buss_info > dim > dim_curr > dim_date > dim_dtyp >