date:20170813

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.
>
>  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  - - [14/Aug/2017:11:39:25 +0800] "POST
> /kylin/api/tables/metric.date_dim/load HTTP/1.1" 500 9919
>
>
>
> 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 {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 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 be loaded
> into.
> >
> >
> >
> > apache_...@163.com
> >
> > From: ShaoFeng Shi
> > Date: 2017-08-13 14:23
> > To: dev
> > Subject: Re: Re: kylin load hive table rest is error
> > 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 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
> > >> dim_gl_acc
> > >> dim_org
> > >> fact1
> > >> fact2
> > >> Time taken: 0.245 seconds, Fetched: 9 row(s)
> > >>
> > >> post url: http://xx.xx.xx.xx:7070/kylin/api/tables/metric.date_
> > >> dim/load
> > >> return error:
> > >> Server returned HTTP response code: 500 for URL:
> > >> http://xx.xx.xx.xx:7070/kylin/api/tables/metric.date_dim/load
> > >>
> > >> but no relevant logs  in kylin.log
> > >>
> > >>
> > >>
> > >>
> > >>
> > >> apache_...@163.com
> > >>
> > >> From: ShaoFeng Shi
> > >> Date: 2017-08-12 14:59
> > >> To: dev
> > >> Subject: Re: kylin load hive table rest is error
> > >> Is there any clue in kylin.log?
> > >>
> > >> 2017-08-12 9:58 GMT+08:00 apache_...@163.com :
> > >>
> > >> >
> > >> > Hi,
> > >> >
> > >> > Please help confirm a question(bug?),when i run load hive table
> by
> > >> > kylin rest interface,  it return a error page info
> > >> >
> > >> >  example:
> > >> >
> > >> >   post   http://xx.xx.xx.xx:7070/kylin/api/metric.date_dim/load
> > >> >  metric.data_dim is hive table, load is kylin project.
> > >> >
> > >> > No body.
> > >> >
> > >> >
> > >> >  return  page info:
> > >> >
> > >> > 
> > >> >  > >> > http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
> > >> > 
> > >> > 
> > >> > 
> > >> > 
> > >> > 
> > >> > 
> > >> > 
> > >> >  > type="image/x-icon">
> > >> > Kylin
> > >> > 
> > >> > 
> > >> > 
> > >> > 
> > >> > 
> > >> >  > >> > ng-include="'partials/header.html'">
> > >> > 
> > >> > 
> > >> > 
> > >> > 
> > >> > 
> > >> >  > >> > ng-include="'partials/footer.html'">
> > >> > 
> > >> > 
> > >> > 
> > >> > 
> > >> > 
> > >> > Error Message
> > >> > {{text}}
> > >> > 
> > >> > 
> > >> > Cube Schema
> > >> > {{schema}}
> > >> > 
> > >> > 
> > >> > 
> > >> > 
> > >> > {{text}}
> > >> > 
> > >> > 
> > >> > 
> > >> > 
> > >> > 
> > >> > 
> > >> > Error Message
> > >> > {{text}}
> > >> > 
> > >> > 
> > >> > Model Schema
> > >> > {{schema}}
> > >> > 
> > >> > 
> > >> > 
> > >> > 
> > >> > {{text}}
> > >> > 
> > >> > 
> > >> > 
> > >> > 
> > >> > 
> > >> >

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  - - [14/Aug/2017:11:39:25 +0800] "POST 
/kylin/api/tables/metric.date_dim/load HTTP/1.1" 500 9919 



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 {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 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 be loaded into.
>
>
>
> apache_...@163.com
>
> From: ShaoFeng Shi
> Date: 2017-08-13 14:23
> To: dev
> Subject: Re: Re: kylin load hive table rest is error
> 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 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
> >> dim_gl_acc
> >> dim_org
> >> fact1
> >> fact2
> >> Time taken: 0.245 seconds, Fetched: 9 row(s)
> >>
> >> post url: http://xx.xx.xx.xx:7070/kylin/api/tables/metric.date_
> >> dim/load
> >> return error:
> >> Server returned HTTP response code: 500 for URL:
> >> http://xx.xx.xx.xx:7070/kylin/api/tables/metric.date_dim/load
> >>
> >> but no relevant logs  in kylin.log
> >>
> >>
> >>
> >>
> >>
> >> apache_...@163.com
> >>
> >> From: ShaoFeng Shi
> >> Date: 2017-08-12 14:59
> >> To: dev
> >> Subject: Re: kylin load hive table rest is error
> >> Is there any clue in kylin.log?
> >>
> >> 2017-08-12 9:58 GMT+08:00 apache_...@163.com :
> >>
> >> >
> >> > Hi,
> >> >
> >> > Please help confirm a question(bug?),when i run load hive table by
> >> > kylin rest interface,  it return a error page info
> >> >
> >> >  example:
> >> >
> >> >   post   http://xx.xx.xx.xx:7070/kylin/api/metric.date_dim/load
> >> >  metric.data_dim is hive table, load is kylin project.
> >> >
> >> > No body.
> >> >
> >> >
> >> >  return  page info:
> >> >
> >> > 
> >> >  >> > http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
> >> > 
> >> > 
> >> > 
> >> > 
> >> > 
> >> > 
> >> > 
> >> >  type="image/x-icon">
> >> > Kylin
> >> > 
> >> > 
> >> > 
> >> > 
> >> > 
> >> >  >> > ng-include="'partials/header.html'">
> >> > 
> >> > 
> >> > 
> >> > 
> >> > 
> >> >  >> > ng-include="'partials/footer.html'">
> >> > 
> >> > 
> >> > 
> >> > 
> >> > 
> >> > Error Message
> >> > {{text}}
> >> > 
> >> > 
> >> > Cube Schema
> >> > {{schema}}
> >> > 
> >> > 
> >> > 
> >> > 
> >> > {{text}}
> >> > 
> >> > 
> >> > 
> >> > 
> >> > 
> >> > 
> >> > Error Message
> >> > {{text}}
> >> > 
> >> > 
> >> > Model Schema
> >> > {{schema}}
> >> > 
> >> > 
> >> > 
> >> > 
> >> > {{text}}
> >> > 
> >> > 
> >> > 
> >> > 
> >> > 
> >> > Error Message
> >> > {{text}}
> >> > 
> >> > 
> >> > Streaming Schema
> >> > {{streamingSchema}}
> >> > 
> >> > 
> >> > Kafka Schema
> >> > {{kfkSchema}}
> >> > 
> >> > 
> >> > 
> >> > 
> >> > {{text}}
> >> > 
> >> > 
> >> > 
> >> > 
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> > apache_...@163.com
>

?????? 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 yet. Could you log a JIRA?

2017-08-11 16:33 GMT+08:00 578300...@qq.com :

> Thank you billy,I know how to solve the problem, but there is another
> error.
>
>
> error
>
>
> [Kylin][ODBC 1.0(w) Driver]The REST query request failed, the error
> message is: Error while executing SQL "SELECT SUM((CASE WHEN ((
> EXTRACT(YEAR FROM "BASEINFO_REPAY_HIS_FACT_PARTATION"."CAL_DATE") = 2017)
> AND ( EXTRACT(MONTH FROM "BASEINFO_REPAY_HIS_FACT_PARTATION"."CAL_DATE")
> = 6)) THEN "BASEINFO_REPAY_HIS_FACT_PARTATION"."REMAIN_CAPITAL_INTEREST"
> ELSE 0 END)) AS "sum_Calculation_FIIAIBABGCIFEFEJ_ok" FROM
> "TN_QUERY"."BASEINFO_REPAY_HIS_FACT_PARTATION"
> "BASEINFO_REPAY_HIS_FACT_PARTATION" LEFT JOIN "TN_QUERY"."DIM_BP_PRODUCT"
> "DIM_BP_PRODUCT" ON ("BASEINFO_REPAY_HIS_FACT_PARTATION"."PRODUCT_CODE" =
> "DIM_BP_PRODUCT"."PRODUCT_CODE") LEFT JOIN "TN_QUERY"."DIM_BP_SALES_CHANNEL"
> "DIM_BP_SALES_CHANNEL" ON ("BASEINFO_REPAY_HIS_FACT_PARTATION"."BUSINESS_TYPE"
> = "DIM_BP_SALES_CHANNEL"."CHANNEL_CODE") LEFT JOIN
> "TN_QUERY"."DIM_FUND_CHANNEL" "DIM_FUND_CHANNEL" ON
> ("BASEINFO_REPAY_HIS_FACT_PARTATION"."ROOT_CODE" =
> "DIM_FUND_CHANNEL"."FUND_CHANNEL_CODE") LEFT JOIN "TN_QUERY"."DIM_ORG"
> "DIM_ORG" ON ("BASEINFO_REPAY_HIS_FACT_PARTATION"."BRANCH_CODE" =
> "DIM_ORG"."BRANCH_CODE") ": Can't find any realization. Please confirm with
> providers. SQL digest: fact table 
> TN_QUERY.BASEINFO_REPAY_HIS_FACT_PARTATION,group
> by [],filter on [],with aggregates[FunctionDesc [expression=SUM,
> parameter=null, returnType=null]].
>
>
>
>
> It seems about "case when" but how to solve it? Thank you.
>
>
>
>
> --  --
> ??: "Billy Liu";;
> : 2017??8??10??(??) 7:32
> ??: "dev";
>
> : Re: The REST query request failed
>
>
>
> This sql is not generated by kylin, Kylin does not generate any query.
> Kylin is read only OLAP system. Kylin accepts SQL and returns query result.
>
> Please try that SQL in Kylin insight tab directly, if not work, you could
> adjust the statement to figure out which one is the incompatible one.
>
> 2017-08-10 17:26 GMT+08:00 578300...@qq.com :
>
> > You mean that the tableau's calculation field query and kylin can not be
> > well fused?
> > Beacause the sql is automatically generated by kylin on the basis of
> > tableau's calculation field.
> > And the environment is:
> > jdk1.7.0_80
> > hadoop-2.5.0-cdh5.3.9
> > hbase-0.98.6-cdh5.3.9
> > apache-kylin-1.6.0
> > tableau 9
> >
> >
> > --  --
> > ??: "Billy Liu";;
> > : 2017??8??10??(??) 5:05
> > ??: "dev";
> >
> > : Re: The REST query request failed
> >
> >
> >
> > The error is clear, some sql grammar did not work in your case, such as
> "{d
> > '2017-06-30'))}"
> >
> > 2017-08-10 15:58 GMT+08:00 578300...@qq.com :
> >
> > > Oh??I see.
> > > I will redescribe with word.
> > >
> > >
> > > I created a calculated field in tableau to judge the date() is or
> not
> > > the last month of last year:
> > > YEAR([])=YEAR(DATEADD('year',-1,[])) and 
> > > MONTH([])=12
> > >
> > >
> > >
> > > when I use the calculated field ,there is an error in kylin.log:
> > > 2017-08-10 15:44:27,279 ERROR [http-bio-7070-exec-2]
> > > controller.BasicController:44 :
> > > org.apache.kylin.rest.exception.InternalErrorException: Encountered
> ")"
> > > at line 1, column 154. Was expecting: "}" ...
> > > at org.apache.kylin.rest.service.
> QueryService.doQueryWithCache(
> > > QueryService.java:391)
> > > at org.apache.kylin.rest.controller.QueryController.
> > > query(QueryController.java:69)
> > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> > > at sun.reflect.NativeMethodAccessorImpl.invoke(
> > > NativeMethodAccessorImpl.java:57)
> > > at sun.reflect.DelegatingMethodAccessorImpl.invoke(
> > > DelegatingMethodAccessorImpl.java:43)
> > > at java.lang.reflect.Method.invoke(Method.java:606)
> > > at org.springframework.web.method.support.
> > InvocableHandlerMethod.
> > > doInvoke(InvocableHandlerMethod.java:221)
> > > at org.springframework.web.method.support.
> > InvocableHandlerMethod.
> > > invokeForRequest(InvocableHandlerMethod.java:136)
> > > at org.springframework.web.servlet.mvc.method.annotation.
> > > ServletInvocableHandlerMethod.invokeAndHandle(
> > > ServletInvocableHandlerMethod.java:104)
> > > at org.springframework.web.servlet.mvc.method.annotation.
> > >

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 {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 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 be loaded into.
>
>
>
> apache_...@163.com
>
> From: ShaoFeng Shi
> Date: 2017-08-13 14:23
> To: dev
> Subject: Re: Re: kylin load hive table rest is error
> 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 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
> >> dim_gl_acc
> >> dim_org
> >> fact1
> >> fact2
> >> Time taken: 0.245 seconds, Fetched: 9 row(s)
> >>
> >> post url: http://xx.xx.xx.xx:7070/kylin/api/tables/metric.date_
> >> dim/load
> >> return error:
> >> Server returned HTTP response code: 500 for URL:
> >> http://xx.xx.xx.xx:7070/kylin/api/tables/metric.date_dim/load
> >>
> >> but no relevant logs  in kylin.log
> >>
> >>
> >>
> >>
> >>
> >> apache_...@163.com
> >>
> >> From: ShaoFeng Shi
> >> Date: 2017-08-12 14:59
> >> To: dev
> >> Subject: Re: kylin load hive table rest is error
> >> Is there any clue in kylin.log?
> >>
> >> 2017-08-12 9:58 GMT+08:00 apache_...@163.com :
> >>
> >> >
> >> > Hi,
> >> >
> >> > Please help confirm a question(bug?),when i run load hive table by
> >> > kylin rest interface,  it return a error page info
> >> >
> >> >  example:
> >> >
> >> >   post   http://xx.xx.xx.xx:7070/kylin/api/metric.date_dim/load
> >> >  metric.data_dim is hive table, load is kylin project.
> >> >
> >> > No body.
> >> >
> >> >
> >> >  return  page info:
> >> >
> >> > 
> >> >  >> > http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
> >> > 
> >> > 
> >> > 
> >> > 
> >> > 
> >> > 
> >> > 
> >> >  type="image/x-icon">
> >> > Kylin
> >> > 
> >> > 
> >> > 
> >> > 
> >> > 
> >> >  >> > ng-include="'partials/header.html'">
> >> > 
> >> > 
> >> > 
> >> > 
> >> > 
> >> >  >> > ng-include="'partials/footer.html'">
> >> > 
> >> > 
> >> > 
> >> > 
> >> > 
> >> > Error Message
> >> > {{text}}
> >> > 
> >> > 
> >> > Cube Schema
> >> > {{schema}}
> >> > 
> >> > 
> >> > 
> >> > 
> >> > {{text}}
> >> > 
> >> > 
> >> > 
> >> > 
> >> > 
> >> > 
> >> > Error Message
> >> > {{text}}
> >> > 
> >> > 
> >> > Model Schema
> >> > {{schema}}
> >> > 
> >> > 
> >> > 
> >> > 
> >> > {{text}}
> >> > 
> >> > 
> >> > 
> >> > 
> >> > 
> >> > Error Message
> >> > {{text}}
> >> > 
> >> > 
> >> > Streaming Schema
> >> > {{streamingSchema}}
> >> > 
> >> > 
> >> > Kafka Schema
> >> > {{kfkSchema}}
> >> > 
> >> > 
> >> > 
> >> > 
> >> > {{text}}
> >> > 
> >> > 
> >> > 
> >> > 
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> > apache_...@163.com
> >> >
> >>
> >>
> >>
> >> --
> >> Best regards,
> >>
> >> Shaofeng Shi 史少锋
> >>
> >
> >
> >
> > --
> > Best regards,
> >
> > Shaofeng Shi 史少锋
> >
> >
>
>
> --
> Best regards,
>
> Shaofeng Shi 史少锋
>

[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
  Components: REST Service
Affects Versions: v1.6.0
 Environment: jdk1.7.0_80, hbase-0.98.6-cdh5.3.9, 
apache-kylin-1.6.0-bin,
Reporter: Shendandan
Assignee: Zhong,Jason
 Fix For: v1.6.0


Use a calculated field in tableau, but it can not work. There is an error in 
kylin.log:

 {{[Kylin][ODBC 1.0(w) Driver]The REST query request failed, the error message 
is: Error while executing SQL "SELECT SUM((CASE WHEN (( EXTRACT(YEAR FROM 
a.column1) = 2017) AND ( EXTRACT(MONTH FROM a.column1) = 6)) THEN a.column2 
ELSE 0 END)) AS "sum_Calculation_FIIAIBABGCIFEFEJ_ok" FROM table a LEFT JOIN 
table b ON (a. column3= b.column1) LEFT JOIN table c ON (a. column4= c.column1) 
LEFT JOIN table d ON (a.column5 = d.column1) LEFT JOIN table e ON (a.column6 = 
e.column1) ": Can't find any realization. Please confirm with providers. SQL 
digest: fact table
a ,group by [],filter on [],with aggregates[FunctionDesc [expression=SUM, 
parameter=null, returnType=null]].}}



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

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", family: "mac"

Thanks,
Dong Li

2017-08-13 14:45 GMT+08:00 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
> KYLIN-2646 - Project level query authorization
>
> And more than 100 bug fixes and enhancements.
>
> Thanks to everyone who has contributed to this release. Here’s release
> notes:
> https://issues.apache.org/jira/secure/ReleaseNote.jspa?proje
> ctId=12316121=12340443
>
> The commit to be voted upon:
>
> https://github.com/apache/kylin/commit/562dd173aaf6b398be8e0
> 53f896755b3afe8137f
>
> Its hash is 562dd173aaf6b398be8e053f896755b3afe8137f.
>
> The artifacts to be voted on are located here:
> https://dist.apache.org/repos/dist/dev/kylin/apache-kylin-2.1.0-rc2/
>
> The hashes of the artifacts are as follows:
> apache-kylin-2.1.0-src.tar.gz.md5 44cab3240772dd1b2e717b48105b416c
> apache-kylin-2.1.0-src.tar.gz.sha1 a3470589523cfa9046d70123d78059
> b913f31b9f
>
> (The binary packages for HBase 1.x and CDH 5.7are also provided for
> testing)
>
> A staged Maven repository is available for review at:
> https://repository.apache.org/content/repositories/orgapachekylin-1043/
>
> Release artifacts are signed with the following key:
> https://people.apache.org/keys/committer/shaofengshi.asc
>
> Please vote on releasing this package as Apache Kylin 2.1.0.
>
> The vote is open for the next 72 hours and passes if a majority of
> at least three +1 PPMC votes are cast.
>
> [ ] +1 Release this package as Apache Kylin 2.1.0
> [ ]  0 I don't feel strongly about it, but I'm okay with the release
> [ ] -1 Do not release this package because...
>
> Here is my vote:
>
> +1 (binding)
>
>
> --
> Best regards,
>
> Shaofeng Shi 史少锋
>

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 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 be loaded into.
>
>
>
> apache_...@163.com
>
> From: ShaoFeng Shi
> Date: 2017-08-13 14:23
> To: dev
> Subject: Re: Re: kylin load hive table rest is error
> 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 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
> >> dim_gl_acc
> >> dim_org
> >> fact1
> >> fact2
> >> Time taken: 0.245 seconds, Fetched: 9 row(s)
> >>
> >> post url: http://xx.xx.xx.xx:7070/kylin/api/tables/metric.date_
> >> dim/load
> >> return error:
> >> Server returned HTTP response code: 500 for URL:
> >> http://xx.xx.xx.xx:7070/kylin/api/tables/metric.date_dim/load
> >>
> >> but no relevant logs  in kylin.log
> >>
> >>
> >>
> >>
> >>
> >> apache_...@163.com
> >>
> >> From: ShaoFeng Shi
> >> Date: 2017-08-12 14:59
> >> To: dev
> >> Subject: Re: kylin load hive table rest is error
> >> Is there any clue in kylin.log?
> >>
> >> 2017-08-12 9:58 GMT+08:00 apache_...@163.com :
> >>
> >> >
> >> > Hi,
> >> >
> >> > Please help confirm a question(bug?),when i run load hive table by
> >> > kylin rest interface,  it return a error page info
> >> >
> >> >  example:
> >> >
> >> >   post   http://xx.xx.xx.xx:7070/kylin/api/metric.date_dim/load
> >> >  metric.data_dim is hive table, load is kylin project.
> >> >
> >> > No body.
> >> >
> >> >
> >> >  return  page info:
> >> >
> >> > 
> >> >  >> > http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
> >> > 
> >> > 
> >> > 
> >> > 
> >> > 
> >> > 
> >> > 
> >> >  type="image/x-icon">
> >> > Kylin
> >> > 
> >> > 
> >> > 
> >> > 
> >> > 
> >> >  >> > ng-include="'partials/header.html'">
> >> > 
> >> > 
> >> > 
> >> > 
> >> > 
> >> >  >> > ng-include="'partials/footer.html'">
> >> > 
> >> > 
> >> > 
> >> > 
> >> > 
> >> > Error Message
> >> > {{text}}
> >> > 
> >> > 
> >> > Cube Schema
> >> > {{schema}}
> >> > 
> >> > 
> >> > 
> >> > 
> >> > {{text}}
> >> > 
> >> > 
> >> > 
> >> > 
> >> > 
> >> > 
> >> > Error Message
> >> > {{text}}
> >> > 
> >> > 
> >> > Model Schema
> >> > {{schema}}
> >> > 
> >> > 
> >> > 
> >> > 
> >> > {{text}}
> >> > 
> >> > 
> >> > 
> >> > 
> >> > 
> >> > Error Message
> >> > {{text}}
> >> > 
> >> > 
> >> > Streaming Schema
> >> > {{streamingSchema}}
> >> > 
> >> > 
> >> > Kafka Schema
> >> > {{kfkSchema}}
> >> > 
> >> > 
> >> > 
> >> > 
> >> > {{text}}
> >> > 
> >> > 
> >> > 
> >> > 
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> > apache_...@163.com
> >> >
> >>
> >>
> >>
> >> --
> >> Best regards,
> >>
> >> Shaofeng Shi 史少锋
> >>
> >
> >
> >
> > --
> > Best regards,
> >
> > Shaofeng Shi 史少锋
> >
> >
>
>
> --
> Best regards,
>
> Shaofeng Shi 史少锋
>

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 be loaded into.



apache_...@163.com
 
From: ShaoFeng Shi
Date: 2017-08-13 14:23
To: dev
Subject: Re: Re: kylin load hive table rest is error
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 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
>> dim_gl_acc
>> dim_org
>> fact1
>> fact2
>> Time taken: 0.245 seconds, Fetched: 9 row(s)
>>
>> post url: http://xx.xx.xx.xx:7070/kylin/api/tables/metric.date_
>> dim/load
>> return error:
>> Server returned HTTP response code: 500 for URL:
>> http://xx.xx.xx.xx:7070/kylin/api/tables/metric.date_dim/load
>>
>> but no relevant logs  in kylin.log
>>
>>
>>
>>
>>
>> apache_...@163.com
>>
>> From: ShaoFeng Shi
>> Date: 2017-08-12 14:59
>> To: dev
>> Subject: Re: kylin load hive table rest is error
>> Is there any clue in kylin.log?
>>
>> 2017-08-12 9:58 GMT+08:00 apache_...@163.com :
>>
>> >
>> > Hi,
>> >
>> > Please help confirm a question(bug?),when i run load hive table by
>> > kylin rest interface,  it return a error page info
>> >
>> >  example:
>> >
>> >   post   http://xx.xx.xx.xx:7070/kylin/api/metric.date_dim/load
>> >  metric.data_dim is hive table, load is kylin project.
>> >
>> > No body.
>> >
>> >
>> >  return  page info:
>> >
>> > 
>> > > > http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
>> > 
>> > 
>> > 
>> > 
>> > 
>> > 
>> > 
>> > 
>> > Kylin
>> > 
>> > 
>> > 
>> > 
>> > 
>> > > > ng-include="'partials/header.html'">
>> > 
>> > 
>> > 
>> > 
>> > 
>> > > > ng-include="'partials/footer.html'">
>> > 
>> > 
>> > 
>> > 
>> > 
>> > Error Message
>> > {{text}}
>> > 
>> > 
>> > Cube Schema
>> > {{schema}}
>> > 
>> > 
>> > 
>> > 
>> > {{text}}
>> > 
>> > 
>> > 
>> > 
>> > 
>> > 
>> > Error Message
>> > {{text}}
>> > 
>> > 
>> > Model Schema
>> > {{schema}}
>> > 
>> > 
>> > 
>> > 
>> > {{text}}
>> > 
>> > 
>> > 
>> > 
>> > 
>> > Error Message
>> > {{text}}
>> > 
>> > 
>> > Streaming Schema
>> > {{streamingSchema}}
>> > 
>> > 
>> > Kafka Schema
>> > {{kfkSchema}}
>> > 
>> > 
>> > 
>> > 
>> > {{text}}
>> > 
>> > 
>> > 
>> > 
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> > apache_...@163.com
>> >
>>
>>
>>
>> --
>> Best regards,
>>
>> Shaofeng Shi 史少锋
>>
>
>
>
> --
> Best regards,
>
> Shaofeng Shi 史少锋
>
>
 
 
-- 
Best regards,
 
Shaofeng Shi 史少锋

[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: Bug
  Components: streaming
Affects Versions: v2.1.0
Reporter: Shaofeng SHI



java.lang.ClassNotFoundException: org.apache.kylin.source.kafka.DateTimeParser
at 
org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1858)



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

[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
KYLIN-2646 - Project level query authorization

And more than 100 bug fixes and enhancements.

Thanks to everyone who has contributed to this release. Here’s release
notes:
https://issues.apache.org/jira/secure/ReleaseNote.jspa?projectId=12316121=12340443

The commit to be voted upon:

https://github.com/apache/kylin/commit/562dd173aaf6b398be8e053f896755b3afe8137f

Its hash is 562dd173aaf6b398be8e053f896755b3afe8137f.

The artifacts to be voted on are located here:
https://dist.apache.org/repos/dist/dev/kylin/apache-kylin-2.1.0-rc2/

The hashes of the artifacts are as follows:
apache-kylin-2.1.0-src.tar.gz.md5 44cab3240772dd1b2e717b48105b416c
apache-kylin-2.1.0-src.tar.gz.sha1 a3470589523cfa9046d70123d78059b913f31b9f

(The binary packages for HBase 1.x and CDH 5.7are also provided for testing)

A staged Maven repository is available for review at:
https://repository.apache.org/content/repositories/orgapachekylin-1043/

Release artifacts are signed with the following key:
https://people.apache.org/keys/committer/shaofengshi.asc

Please vote on releasing this package as Apache Kylin 2.1.0.

The vote is open for the next 72 hours and passes if a majority of
at least three +1 PPMC votes are cast.

[ ] +1 Release this package as Apache Kylin 2.1.0
[ ]  0 I don't feel strongly about it, but I'm okay with the release
[ ] -1 Do not release this package because...

Here is my vote:

+1 (binding)


-- 
Best regards,

Shaofeng Shi 史少锋

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 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
>> dim_gl_acc
>> dim_org
>> fact1
>> fact2
>> Time taken: 0.245 seconds, Fetched: 9 row(s)
>>
>> post url: http://xx.xx.xx.xx:7070/kylin/api/tables/metric.date_
>> dim/load
>> return error:
>> Server returned HTTP response code: 500 for URL:
>> http://xx.xx.xx.xx:7070/kylin/api/tables/metric.date_dim/load
>>
>> but no relevant logs  in kylin.log
>>
>>
>>
>>
>>
>> apache_...@163.com
>>
>> From: ShaoFeng Shi
>> Date: 2017-08-12 14:59
>> To: dev
>> Subject: Re: kylin load hive table rest is error
>> Is there any clue in kylin.log?
>>
>> 2017-08-12 9:58 GMT+08:00 apache_...@163.com :
>>
>> >
>> > Hi,
>> >
>> > Please help confirm a question(bug?),when i run load hive table by
>> > kylin rest interface,  it return a error page info
>> >
>> >  example:
>> >
>> >   post   http://xx.xx.xx.xx:7070/kylin/api/metric.date_dim/load
>> >  metric.data_dim is hive table, load is kylin project.
>> >
>> > No body.
>> >
>> >
>> >  return  page info:
>> >
>> > 
>> > > > http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
>> > 
>> > 
>> > 
>> > 
>> > 
>> > 
>> > 
>> > 
>> > Kylin
>> > 
>> > 
>> > 
>> > 
>> > 
>> > > > ng-include="'partials/header.html'">
>> > 
>> > 
>> > 
>> > 
>> > 
>> > > > ng-include="'partials/footer.html'">
>> > 
>> > 
>> > 
>> > 
>> > 
>> > Error Message
>> > {{text}}
>> > 
>> > 
>> > Cube Schema
>> > {{schema}}
>> > 
>> > 
>> > 
>> > 
>> > {{text}}
>> > 
>> > 
>> > 
>> > 
>> > 
>> > 
>> > Error Message
>> > {{text}}
>> > 
>> > 
>> > Model Schema
>> > {{schema}}
>> > 
>> > 
>> > 
>> > 
>> > {{text}}
>> > 
>> > 
>> > 
>> > 
>> > 
>> > Error Message
>> > {{text}}
>> > 
>> > 
>> > Streaming Schema
>> > {{streamingSchema}}
>> > 
>> > 
>> > Kafka Schema
>> > {{kfkSchema}}
>> > 
>> > 
>> > 
>> > 
>> > {{text}}
>> > 
>> > 
>> > 
>> > 
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> > apache_...@163.com
>> >
>>
>>
>>
>> --
>> Best regards,
>>
>> Shaofeng Shi 史少锋
>>
>
>
>
> --
> Best regards,
>
> Shaofeng Shi 史少锋
>
>


-- 
Best regards,

Shaofeng Shi 史少锋

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
> dim_gl_acc
> dim_org
> fact1
> fact2
> Time taken: 0.245 seconds, Fetched: 9 row(s)
>
> post url: http://xx.xx.xx.xx:7070/kylin/api/tables/metric.date_dim/
> load
> return error:
> Server returned HTTP response code: 500 for URL:
> http://xx.xx.xx.xx:7070/kylin/api/tables/metric.date_dim/load
>
> but no relevant logs  in kylin.log
>
>
>
>
>
> apache_...@163.com
>
> From: ShaoFeng Shi
> Date: 2017-08-12 14:59
> To: dev
> Subject: Re: kylin load hive table rest is error
> Is there any clue in kylin.log?
>
> 2017-08-12 9:58 GMT+08:00 apache_...@163.com :
>
> >
> > Hi,
> >
> > Please help confirm a question(bug?),when i run load hive table by
> > kylin rest interface,  it return a error page info
> >
> >  example:
> >
> >   post   http://xx.xx.xx.xx:7070/kylin/api/metric.date_dim/load
> >  metric.data_dim is hive table, load is kylin project.
> >
> > No body.
> >
> >
> >  return  page info:
> >
> > 
> >  > http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > Kylin
> > 
> > 
> > 
> > 
> > 
> >  > ng-include="'partials/header.html'">
> > 
> > 
> > 
> > 
> > 
> >  > ng-include="'partials/footer.html'">
> > 
> > 
> > 
> > 
> > 
> > Error Message
> > {{text}}
> > 
> > 
> > Cube Schema
> > {{schema}}
> > 
> > 
> > 
> > 
> > {{text}}
> > 
> > 
> > 
> > 
> > 
> > 
> > Error Message
> > {{text}}
> > 
> > 
> > Model Schema
> > {{schema}}
> > 
> > 
> > 
> > 
> > {{text}}
> > 
> > 
> > 
> > 
> > 
> > Error Message
> > {{text}}
> > 
> > 
> > Streaming Schema
> > {{streamingSchema}}
> > 
> > 
> > Kafka Schema
> > {{kfkSchema}}
> > 
> > 
> > 
> > 
> > {{text}}
> > 
> > 
> > 
> > 
> >
> >
> >
> >
> >
> >
> >
> > apache_...@163.com
> >
>
>
>
> --
> Best regards,
>
> Shaofeng Shi 史少锋
>



-- 
Best regards,

Shaofeng Shi 史少锋

Error Message

Cube Schema

Error Message

Model Schema

Error Message

Cube Schema

Error Message

Model Schema

Error Message

Streaming Schema

Kafka Schema

Error Message

Cube Schema

Error Message

Model Schema

Error Message

Streaming Schema

Kafka Schema

Error Message

Cube Schema

Error Message

Model Schema

Error Message

Streaming Schema

Kafka Schema

Error Message

Cube Schema

Error Message

Model Schema

Error Message

Streaming Schema

Kafka Schema

Error Message

Cube Schema

Error Message

Model Schema

Error Message

Streaming Schema

Kafka Schema

Error Message

Cube Schema

Error Message

Model Schema

Error Message

Streaming Schema

Kafka Schema

12 matches

Mail list logo