Query failed
When I use >=, there is data query, when I add <=, the query is wrong.
==[QUERY]===
Query Id: a2095b23-f09c-4cd7-9969-e0ad98746dc3
SQL: SELECT "HYNAME" AS "HYNAME",
SUM(QY_SUM)-SUM(QY_SUM_PRE) AS "FLOW_IN_ENTERPRISE"
FROM
(SELECT CAST(T.PAYMENT_DATE AS DATE) AS CAL_DATE,
CONCAT(CAST(S.CALENDARYEAR AS CHAR(4)),'?') AS CAL_DATE_YEAR,
CONCAT(CAST(S.CALENDARQUARTER AS CHAR(4)),'??') AS CAL_DATE_QUARTER,
CASE
WHEN S.CALENDARMONTH<10 THEN
CONCAT(CONCAT('0',CAST(S.CALENDARMONTH AS CHAR(4))),'?')
ELSE CONCAT(CAST(S.CALENDARMONTH AS CHAR(4)),'?')
END AS CAL_DATE_MONTH,
T.INDUSTRY_CATEGORY_NAME AS HYNAME,
T.COMPANY_CNT AS QY_SUM,
T.COMPANY_CNT_ROW AS QY_SUM_ROW,
T.COMPANY_CNT_BEFORE AS QY_SUM_PRE,
T.COMPANY_CNT_GROWTH_PERCENT AS QY_SUM_PERC,
(T.COMPANY_CNT-T.COMPANY_CNT_BEFORE) AS QY_SUM_GROWTH,
T.SUM_EMNUM AS YG_SUM,
T.SUM_EMNUM_ROW AS YG_SUM_ROW,
T.SUM_EMNUM_BEFORE AS YG_SUM_PRE,
T.SUM_EMNUM_GROWTH_PERCENT AS YG_SUM_PERC,
(T.SUM_EMNUM-T.SUM_EMNUM_BEFORE) AS YG_SUM_GROWTH,
T.SUM_REGISTERED_CAPITAL AS RC_SUM,
T.SUM_REGISTERED_CAPITAL_ROW AS RC_SUM_ROW,
T.SUM_REGISTERED_CAPITAL_BEFORE AS RC_SUM_PRE,
T.SUM_REGISTERED_CAPITAL_GROWTH_PERCENT AS RC_SUM_PERC,
(T.SUM_REGISTERED_CAPITAL-T.SUM_REGISTERED_CAPITAL_BEFORE) AS
RC_SUM_GROWTH,
T.SUM_OPERATING_LIFE AS OL_SUM,
T.SUM_OPERATING_LIFE_ROW AS OL_SUM_ROW
FROM INDUSTRY_RANK T
LEFT JOIN INDUSTRY_RANK_DATE S ON T.SYS_ID=S.SYS_ID) AS expr_qry
WHERE "CAL_DATE" >= TO_DATE('2011-09-20 00:00:00', '-MM-dd')
AND "CAL_DATE" <= TO_DATE('2018-09-20 01:33:04', '-MM-dd')
GROUP BY "HYNAME"
ORDER BY "FLOW_IN_ENTERPRISE" DESC
LIMIT 10;
User: ADMIN
Success: true
Duration: 0.226
Project: WEIHAI_DEMO
Realization Names: [CUBE[name=Cube_INDUSTRY_RANK]]
Cuboid Ids: [524287]
Total scan count: 0
Total scan bytes: 0
Result row count: 0
Accept Partial: true
Is Partial Result: false
Hit Exception Cache: false
Storage cache used: false
Is Query Push-Down: false
Is Prepare: false
Trace URL: null
Message: null
==[QUERY]===
zhengyangju...@163.com
[jira] [Created] (KYLIN-3572) Upgrade commons-dbcp to latest commons-dbcp2
Ted Yu created KYLIN-3572: - Summary: Upgrade commons-dbcp to latest commons-dbcp2 Key: KYLIN-3572 URL: https://issues.apache.org/jira/browse/KYLIN-3572 Project: Kylin Issue Type: Task Reporter: Ted Yu There have been many improvements and a major release in commons-dbcp. The latest version is 2.5.0. This Jira proposes to upgrade the version of commons-dbcp to commons-dbcp2 version 2.5.0 in order to benefit from the improvements/additions. This will involve some code changes in addition to the updated dependencies, as the API has changed slightly to use different terminology -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Created] (KYLIN-3571) Not build Spark in Kylin's binary package
Shaofeng SHI created KYLIN-3571: --- Summary: Not build Spark in Kylin's binary package Key: KYLIN-3571 URL: https://issues.apache.org/jira/browse/KYLIN-3571 Project: Kylin Issue Type: Improvement Components: Environment Reporter: Shaofeng SHI -- This message was sent by Atlassian JIRA (v7.6.3#76005)
Re: [Discuss] Exclude Spark from Kylin's binary package
Thanks for billy's comment; A JIRA is created for this change: https://issues.apache.org/jira/browse/KYLIN-3571 Billy Liu 于2018年9月18日周二 下午10:35写道： > I like the idea to remove the built-in spark distribution. I think > Kylin could work well with all spark 2.1+ > > With Warm regards > > Billy Liu > > ShaoFeng Shi 于2018年9月18日周二 下午5:35写道： > > > > Hello, > > > > Today Kylin's binary package ships an Apache Spark binary, the total > package is 297 MB in v2.5.0; I noticed that if the package is above 300 MB, > it would be rejected by Apache SVN. Now in the whole package, Spark takes > about 200 MB. Later when we upgrade to a higher version, the package can be > bigger. Without spark, the package is around 100 MB. > > > > Since we don't have customization to Spark, we can provide a > download-spark.sh script for the user to easily download. If the user > already has that in local, he just needs to copy or create a symbolic link > in Kylin folder. > > > > This will reduce 2/3 package size, and save time/bandwidth for > distributing Kylin. If you see a problem this change may bring, please > complain. > > > > -- > > Best regards, > > > > Shaofeng Shi 史少锋 > > > -- Best regards, Shaofeng Shi 史少锋
TOPN
What is the solution for the row_number() function? I need to take the group TOPN I am using kylin 2.4.1. What is the link to the list of functions supported by kylin? zhengyangju...@163.com
答复: kylin config beelline error
Hi hzxieyufeng, The exact problem should be "Cannot modify dfs.replication at runtime". You may try to comment this configuration in kylin_hive_conf.xml, or set Hive configuraiton hive.security.authorization.sqlstd.confwhitelist to allow such configuration to be changed at runtime. Thanks, Silas 发件人: hzxieyufeng 发送时间: 2018年9月12日 17:48 收件人: dev 主题: kylin config beelline error hi, I can't get hive metastore or mysql. I only use hive with beeline mode. when is run sample.sh 。I meet this problem。 Retrieving hadoop conf dir... Loading sample data into HDFS tmp path: /tmp/kylin/sample_cube/data put: `/tmp/kylin/sample_cube/data/DEFAULT.KYLIN_ACCOUNT.csv': File exists put: `/tmp/kylin/sample_cube/data/DEFAULT.KYLIN_CAL_DT.csv': File exists put: `/tmp/kylin/sample_cube/data/DEFAULT.KYLIN_CATEGORY_GROUPINGS.csv': File exists put: `/tmp/kylin/sample_cube/data/DEFAULT.KYLIN_COUNTRY.csv': File exists put: `/tmp/kylin/sample_cube/data/DEFAULT.KYLIN_SALES.csv': File exists Going to create sample tables in hive to database DEFAULT by beeline ls: cannot access /home/recsys/hive-jd/lib/hive-jdbc-*-standalone.jar: No such file or directory SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in [jar:file:/home/recsys/hive-jd/lib/log4j-slf4j-impl-2.4.1.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [jar:file:/home/recsys/hadoop-jd/share/hadoop/common/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory] Connecting to jdbc:hive2://hive1.jd.163.org:12181,hive2.jd.163.org:12181,spark5.jd.163.org:12181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hive-cluster9;principal=hive/_h...@hadoop2.hz.netease.com 18/09/12 17:23:38 [main]: INFO jdbc.HiveConnection: Connected to hive3.jd.163.org:10010 18/09/12 17:23:38 [main]: ERROR jdbc.HiveConnection: Error opening session org.apache.thrift.protocol.TProtocolException: Required field 'serverProtocolVersion' is unset! Struct:TOpenSessionResp(status:TStatus(statusCode:ERROR_STATUS, infoMessages:[*org.apache.hive.service.cli.HiveSQLException:Failed to open new session: java.lang.IllegalArgumentException: Cannot modify dfs.replication at runtime. It is not in list of params that are allowed to be modified at runtime:14:13, org.apache.hive.service.cli.session.SessionManager:createSession:SessionManager.java:336, org.apache.hive.service.cli.session.SessionManager:openSession:SessionManager.java:279, org.apache.hive.service.cli.CLIService:openSessionWithImpersonation:CLIService.java:189, org.apache.hive.service.cli.thrift.ThriftCLIService:getSessionHandle:ThriftCLIService.java:431, org.apache.hive.service.cli.thrift.ThriftCLIService:OpenSession:ThriftCLIService.java:313, org.apache.hive.service.rpc.thrift.TCLIService$Processor$OpenSession:getResult:TCLIService.java:1377, org.apache.hive.service.rpc.thrift.TCLIService$Processor$OpenSession:getResult:TCLIService.java:1362, org.apache.thrift.ProcessFunction:process:ProcessFunction.java:39, org.apache.thrift.TBaseProcessor:process:TBaseProcessor.java:39, org.apache.hadoop.hive.thrift.HadoopThriftAuthBridge$Server$TUGIAssumingProcessor:process:HadoopThriftAuthBridge.java:599, org.apache.thrift.server.TThreadPoolServer$WorkerProcess:run:TThreadPoolServer.java:286, java.util.concurrent.ThreadPoolExecutor:runWorker:ThreadPoolExecutor.java:1149, java.util.concurrent.ThreadPoolExecutor$Worker:run:ThreadPoolExecutor.java:624, java.lang.Thread:run:Thread.java:748, *org.apache.hive.service.cli.HiveSQLException:java.lang.IllegalArgumentException: Cannot modify dfs.replication at runtime. It is not in list of params that are allowed to be modified at runtime:27:13, org.apache.hive.service.cli.session.HiveSessionImpl:configureSession:HiveSessionImpl.java:264, org.apache.hive.service.cli.session.HiveSessionImpl:open:HiveSessionImpl.java:189, sun.reflect.GeneratedMethodAccessor180:invoke::-1, sun.reflect.DelegatingMethodAccessorImpl:invoke:DelegatingMethodAccessorImpl.java:43, java.lang.reflect.Method:invoke:Method.java:498, org.apache.hive.service.cli.session.HiveSessionProxy:invoke:HiveSessionProxy.java:78, org.apache.hive.service.cli.session.HiveSessionProxy:access$000:HiveSessionProxy.java:36, org.apache.hive.service.cli.session.HiveSessionProxy$1:run:HiveSessionProxy.java:63, java.security.AccessController:doPrivileged:AccessController.java:-2, javax.security.auth.Subject:doAs:Subject.java:422, org.apache.hadoop.security.UserGroupInformation:doAs:UserGroupInformation.java:1698, org.apache.hive.service.cli.session.HiveSessionProxy:invoke:HiveSessionProxy.java:59, com.sun.proxy.$Proxy48:open::-1, org.apache.hive.service.cli.session.SessionManager:createSession:SessionManager.java:327, *java.lang.IllegalArgumentException:Cannot modify
Re: [Announce] Apache Kylin 2.5.0 released
Thanks Shaofeng. I think this is one of the most remarkable releases since 2.0. A few highlights: [KYLIN-3521] - Enable Cube Planner by default [KYLIN-2565] - Support Hadoop 3.0 [KYLIN-3033] - Support HBase 2.0 [KYLIN-3418] - User interface for hybrid model [KYLIN-3427] - Convert to HFile in Spark [KYLIN-3441] - Merge cube segments in Spark [KYLIN-3442] - Fact distinct columns in Spark [KYLIN-3453] - Improve cube size estimation for TOPN, COUNT DISTINCT and a lot of bug fixes and improvement on stability. With Warm regards Billy Liu ShaoFeng Shi 于2018年9月19日周三 上午8:31写道： > > The Apache Kylin team is pleased to announce the immediate availability of > the 2.5.0 release. > > This is a major release after 2.4, with more than 100 enhancements and bug > fixes. All of the changes in this release can be found in: > https://kylin.apache.org/docs/release_notes.html > > You can download the source release and binary packages from Apache Kylin's > download page: https://kylin.apache.org/download/ > > Apache Kylin is an open source Distributed Analytics Engine designed to > provide SQL interface and multi-dimensional analysis (OLAP) on Apache Hadoop, > supporting extremely large datasets. > > Apache Kylin lets you query massive dataset at sub-second latency in 3 steps: > 1. Identify a star schema or snowflake schema data set on Hadoop. > 2. Build Cube on Hadoop. > 3. Query data with ANSI-SQL and get results in sub-second, via ODBC, JDBC or > RESTful API. > > Thanks to everyone who has contributed to the 2.5.0 release. > > We welcome your help and feedback. For more information on how to > report problems, and to get involved, visit the project website at > https://kylin.apache.org/ > > -- > Best regards, > > Shaofeng Shi 史少锋 >
***UNCHECKED*** Re: Re: ***UNCHECKED*** apache-kylin-2.4.1-source-release源码编译错误
i'm ok ,because used win 7,when change linux success zhengyangju...@163.com 发件人： Zhong, Yanghong 发送时间： 2018-09-19 18:03 收件人： dev@kylin.apache.org 主题： Re: ***UNCHECKED*** apache-kylin-2.4.1-source-release源码编译错误 My Environment. [INFO] Reactor Summary: [INFO] [INFO] Apache Kylin 2.4.1 . SUCCESS [ 2.934 s] [INFO] Apache Kylin - Calcite Overrides ... SUCCESS [ 4.848 s] [INFO] Apache Kylin - Core Common . SUCCESS [ 5.619 s] [INFO] Apache Kylin - Core Metadata ... SUCCESS [ 8.432 s] [INFO] Apache Kylin - Core Dictionary . SUCCESS [ 4.302 s] [INFO] Apache Kylin - Core Cube ... SUCCESS [ 7.044 s] [INFO] Apache Kylin - Core Metrics SUCCESS [ 2.536 s] [INFO] Apache Kylin - Core Job SUCCESS [ 3.757 s] [INFO] Apache Kylin - Core Storage SUCCESS [ 3.543 s] [INFO] Apache Kylin - MapReduce Engine SUCCESS [ 7.757 s] [INFO] Apache Kylin - HBase Storage ... SUCCESS [ 11.192 s] [INFO] Apache Kylin - Spark Engine SUCCESS [ 10.194 s] [INFO] Apache Kylin - Hive Source . SUCCESS [ 7.301 s] [INFO] Apache Kylin - Kafka Source SUCCESS [ 5.532 s] [INFO] Apache Kylin - Query ... SUCCESS [ 8.240 s] [INFO] Apache Kylin - Metrics Reporter Hive ... SUCCESS [ 6.497 s] [INFO] Apache Kylin - Metrics Reporter Kafka .. SUCCESS [ 4.755 s] [INFO] Apache Kylin - REST Server Base SUCCESS [01:19 min] [INFO] Apache Kylin - REST Server . SUCCESS [ 31.784 s] [INFO] Apache Kylin - JDBC Driver . SUCCESS [ 6.399 s] [INFO] Apache Kylin - Assembly SUCCESS [ 3.787 s] [INFO] Apache Kylin - Tool SUCCESS [ 17.275 s] [INFO] Apache Kylin - Tool Assembly ... SUCCESS [ 2.937 s] [INFO] Apache Kylin - Integration Test SUCCESS [ 15.029 s] [INFO] Apache Kylin - Tomcat Extension 2.4.1 .. SUCCESS [ 2.726 s] [INFO] [INFO] BUILD SUCCESS [INFO] [INFO] Total time: 04:23 min [INFO] Finished at: 2018-09-19T18:00:11+08:00 [INFO] LM-SHC-16501214:apache-kylin-2.4.1 yangzhong$ mvn -v Apache Maven 3.5.4 (1edded0938998edf8bf061f1ceb3cfdeccf443fe; 2018-06-18T02:33:14+08:00) Maven home: /Users/yangzhong/Software/apache-maven-3.5.4 Java version: 1.8.0_66, vendor: Oracle Corporation, runtime: /Library/Java/JavaVirtualMachines/jdk1.8.0_66.jdk/Contents/Home/jre Default locale: en_US, platform encoding: UTF-8 OS name: "mac os x", version: "10.11.6", arch: "x86_64", family: "mac" --- On 9/19/18, 5:29 PM, "zhengyangju...@163.com" wrote: [INFO] Apache Kylin ... SUCCESS [ 15.251 s] [INFO] Apache Kylin - Calcite Overrides ... SUCCESS [ 15.367 s] [INFO] Apache Kylin - Core Common . SUCCESS [ 19.785 s] [INFO] Apache Kylin - Core Metadata ... SUCCESS [ 26.025 s] [INFO] Apache Kylin - Core Dictionary . SUCCESS [ 15.878 s] [INFO] Apache Kylin - Core Cube ... SUCCESS [ 20.138 s] [INFO] Apache Kylin - Core Metrics SUCCESS [ 6.857 s] [INFO] Apache Kylin - Core Job SUCCESS [ 12.018 s] [INFO] Apache Kylin - Core Storage SUCCESS [ 13.219 s] [INFO] Apache Kylin - MapReduce Engine SUCCESS [ 22.492 s] [INFO] Apache Kylin - HBase Storage ... SUCCESS [ 26.064 s] [INFO] Apache Kylin - Spark Engine FAILURE [ 9.034 s] [INFO] Apache Kylin - Hive Source . SKIPPED [INFO] Apache Kylin - Kafka Source SKIPPED [INFO] Apache Kylin - Query ... SKIPPED [INFO] Apache Kylin - Metrics Reporter Hive ... SKIPPED [INFO] Apache Kylin - Metrics Reporter Kafka .. SKIPPED [INFO] Apache Kylin - REST Server Base SKIPPED [INFO] Apache Kylin - REST Server . SKIPPED [INFO] Apache Kylin - JDBC Driver . SKIPPED [INFO] Apache Kylin - Assembly
Re: Query failed
Runs successfully when I use the >= symbol alone
==[QUERY]===
Query Id: e831aa51-6c6b-42d8-b683-e0060398f43b
SQL: SELECT "HYNAME" AS "HYNAME",
SUM(QY_SUM)-SUM(QY_SUM_PRE) AS "FLOW_IN_ENTERPRISE"
FROM
(SELECT CAST(T.PAYMENT_DATE AS DATE) AS CAL_DATE,
CONCAT(CAST(S.CALENDARYEAR AS CHAR(4)),'?') AS CAL_DATE_YEAR,
CONCAT(CAST(S.CALENDARQUARTER AS CHAR(4)),'??') AS CAL_DATE_QUARTER,
CASE
WHEN S.CALENDARMONTH<10 THEN
CONCAT(CONCAT('0',CAST(S.CALENDARMONTH AS CHAR(4))),'?')
ELSE CONCAT(CAST(S.CALENDARMONTH AS CHAR(4)),'?')
END AS CAL_DATE_MONTH,
T.INDUSTRY_CATEGORY_NAME AS HYNAME,
T.COMPANY_CNT AS QY_SUM,
T.COMPANY_CNT_ROW AS QY_SUM_ROW,
T.COMPANY_CNT_BEFORE AS QY_SUM_PRE,
T.COMPANY_CNT_GROWTH_PERCENT AS QY_SUM_PERC,
(T.COMPANY_CNT-T.COMPANY_CNT_BEFORE) AS QY_SUM_GROWTH,
T.SUM_EMNUM AS YG_SUM,
T.SUM_EMNUM_ROW AS YG_SUM_ROW,
T.SUM_EMNUM_BEFORE AS YG_SUM_PRE,
T.SUM_EMNUM_GROWTH_PERCENT AS YG_SUM_PERC,
(T.SUM_EMNUM-T.SUM_EMNUM_BEFORE) AS YG_SUM_GROWTH,
T.SUM_REGISTERED_CAPITAL AS RC_SUM,
T.SUM_REGISTERED_CAPITAL_ROW AS RC_SUM_ROW,
T.SUM_REGISTERED_CAPITAL_BEFORE AS RC_SUM_PRE,
T.SUM_REGISTERED_CAPITAL_GROWTH_PERCENT AS RC_SUM_PERC,
(T.SUM_REGISTERED_CAPITAL-T.SUM_REGISTERED_CAPITAL_BEFORE) AS
RC_SUM_GROWTH,
T.SUM_OPERATING_LIFE AS OL_SUM,
T.SUM_OPERATING_LIFE_ROW AS OL_SUM_ROW
FROM INDUSTRY_RANK T
LEFT JOIN INDUSTRY_RANK_DATE S ON T.SYS_ID=S.SYS_ID) AS expr_qry
WHERE "CAL_DATE" >= TO_DATE('2011-09-20 00:00:00', '-MM-dd')
GROUP BY "HYNAME"
ORDER BY "FLOW_IN_ENTERPRISE" DESC
LIMIT 10;
User: ADMIN
Success: true
Duration: 0.216
Project: WEIHAI_DEMO
Realization Names: [CUBE[name=Cube_INDUSTRY_RANK]]
Cuboid Ids: [524287]
Total scan count: 7709
Total scan bytes: 562757
Result row count: 10
Accept Partial: true
Is Partial Result: false
Hit Exception Cache: false
Storage cache used: false
Is Query Push-Down: false
Is Prepare: false
Trace URL: null
Message: null
==[QUERY]===
Results are as follows:
其他未列明零售业
2086
建材批发
925
服装批发
774
建筑装饰业
715
机织服装制造
668
其他未列明商务服务业
552
其他专业咨询
459
When I use <= alone, an unknown error occurs, the log is as follows:
==[QUERY]===
Query Id: 34c40b98-095a-4085-82f9-8f3c72848cdd
SQL: SELECT "HYNAME" AS "HYNAME",
SUM(QY_SUM)-SUM(QY_SUM_PRE) AS "FLOW_IN_ENTERPRISE"
FROM
(SELECT CAST(T.PAYMENT_DATE AS DATE) AS CAL_DATE,
CONCAT(CAST(S.CALENDARYEAR AS CHAR(4)),'?') AS CAL_DATE_YEAR,
CONCAT(CAST(S.CALENDARQUARTER AS CHAR(4)),'??') AS CAL_DATE_QUARTER,
CASE
WHEN S.CALENDARMONTH<10 THEN
CONCAT(CONCAT('0',CAST(S.CALENDARMONTH AS CHAR(4))),'?')
ELSE CONCAT(CAST(S.CALENDARMONTH AS CHAR(4)),'?')
END AS CAL_DATE_MONTH,
T.INDUSTRY_CATEGORY_NAME AS HYNAME,
T.COMPANY_CNT AS QY_SUM,
T.COMPANY_CNT_ROW AS QY_SUM_ROW,
T.COMPANY_CNT_BEFORE AS QY_SUM_PRE,
T.COMPANY_CNT_GROWTH_PERCENT AS QY_SUM_PERC,
(T.COMPANY_CNT-T.COMPANY_CNT_BEFORE) AS QY_SUM_GROWTH,
T.SUM_EMNUM AS YG_SUM,
T.SUM_EMNUM_ROW AS YG_SUM_ROW,
T.SUM_EMNUM_BEFORE AS YG_SUM_PRE,
T.SUM_EMNUM_GROWTH_PERCENT AS YG_SUM_PERC,
(T.SUM_EMNUM-T.SUM_EMNUM_BEFORE) AS YG_SUM_GROWTH,
T.SUM_REGISTERED_CAPITAL AS RC_SUM,
T.SUM_REGISTERED_CAPITAL_ROW AS RC_SUM_ROW,
T.SUM_REGISTERED_CAPITAL_BEFORE AS RC_SUM_PRE,
T.SUM_REGISTERED_CAPITAL_GROWTH_PERCENT AS RC_SUM_PERC,
(T.SUM_REGISTERED_CAPITAL-T.SUM_REGISTERED_CAPITAL_BEFORE) AS
RC_SUM_GROWTH,
T.SUM_OPERATING_LIFE AS OL_SUM,
T.SUM_OPERATING_LIFE_ROW AS OL_SUM_ROW
FROM INDUSTRY_RANK T
LEFT JOIN INDUSTRY_RANK_DATE S ON T.SYS_ID=S.SYS_ID) AS expr_qry
WHERE
"CAL_DATE" <= TO_DATE('2018-09-20 01:33:04', '-MM-dd')
GROUP BY "HYNAME"
ORDER BY "FLOW_IN_ENTERPRISE" DESC
LIMIT 10;
User: ADMIN
Success: true
Duration: 0.276
Project: WEIHAI_DEMO
Realization Names: [CUBE[name=Cube_INDUSTRY_RANK]]
Cuboid Ids: [524287]
Total scan count: 0
Total scan bytes: 0
Result row count: 0
Accept Partial: true
Is Partial Result: false
Hit Exception Cache: false
Storage cache used: false
Is Query Push-Down: false
Is Prepare: false
Trace URL: null
Message: null
==[QUERY]===
2018-09-20 10:15:36,174 DEBUG [Query c4dc6f83-8c9d-4fa3-8485-00bd6742136e-189]
hbase.HBaseConnection:180 : Using the working dir FS for HBase:
hdfs://nameservice
2018-09-20 10:15:36,174 DEBUG [Query
Re: ***UNCHECKED*** apache-kylin-2.4.1-source-release源码编译错误
Hi yangjun,
Which java version do you use for mvn? It may need java 1.8.
Best,
Yanghong Zhong
On 9/19/18, 5:17 PM, "yangz_sh" wrote:
[INFO] Apache Kylin ... SUCCESS [ 15.251
s][INFO] Apache Kylin - Calcite Overrides ... SUCCESS [
15.367 s][INFO] Apache Kylin - Core Common . SUCCESS
[ 19.785 s][INFO] Apache Kylin - Core Metadata ...
SUCCESS [ 26.025 s][INFO] Apache Kylin - Core Dictionary
. SUCCESS [ 15.878 s][INFO] Apache Kylin - Core Cube
... SUCCESS [ 20.138 s][INFO] Apache Kylin - Core
Metrics SUCCESS [ 6.857 s][INFO] Apache Kylin -
Core Job SUCCESS [ 12.018 s][INFO] Apache Kylin
- Core Storage SUCCESS [ 13.219 s][INFO] Apache
Kylin - MapReduce Engine SUCCESS [ 22.492 s][INFO]
Apache Kylin - HBase Storage ... SUCCESS [ 26.064
s][INFO] Apache Kylin - Spark Engine FAILURE [
9.034 s][INFO] Apache Kylin - Hive Source .
SKIPPED[INFO] Apache Kylin - Kafka Source
SKIPPED[INFO] Apache Kylin - Query ...
SKIPPED[INFO] Apache Kylin - Metrics Reporter Hive ...
SKIPPED[INFO] Apache Kylin - Metrics Reporter Kafka ..
SKIPPED[INFO] Apache Kylin - REST Server Base
SKIPPED[INFO] Apache Kylin - REST Server .
SKIPPED[INFO] Apache Kylin - JDBC Driver .
SKIPPED[INFO] Apache Kylin - Assembly
SKIPPED[INFO] Apache Kylin - Tool
SKIPPED[INFO] Apache Kylin - Tool Assembly ...
SKIPPED[INFO] Apache Kylin - Integration Test
SKIPPED[INFO] Apache Kylin - Tomcat Extension
SKIPPED[INFO]
[INFO]
BUILD FAILURE[INFO]
[INFO]
Total time: 03:23 min[INFO] Finished at: 2018-09-19T17:16:15+08:00[INFO]
Final Memory: 54M/261M[INFO]
[ERROR]
Failed to execute goal
org.apache.maven.plugins:maven-remote-resources-plugin:1.5:process
(process-resource-bundles) on project kylin-engine-spark: Execution
process-resource-bundles of goal
org.apache.maven.plugins:maven-remote-resources-plugin:1.5:process failed:
For artifact {null:null:null:jar}: The groupId cannot be empty. -> [Help
1]org.apache.maven.lifecycle.LifecycleExecutionException: Failed to execute
goal org.apache.maven.plugins:maven-remote-resources-plugin:1.5:process
(process-resource-bundles) on project kylin-engine-spark: Execution
process-resource-bundles of goal
org.apache.maven.plugins:maven-remote-resources-plugin:1.5:process failed:
For artifact {null:null:null:jar}: The groupId cannot be empty.at
org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:212)
at
org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:153)
at
org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:145)
at
org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:116)
at
org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:80)
at
org.apache.maven.lifecycle.internal.builder.singlethreaded.SingleThreadedBuilder.build(SingleThreadedBuilder.java:51)
at
org.apache.maven.lifecycle.internal.LifecycleStarter.execute(LifecycleStarter.java:128)
at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:307)at
org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:193)at
org.apache.maven.DefaultMaven.execute(DefaultMaven.java:106)at
org.apache.maven.cli.MavenCli.execute(MavenCli.java:863)at
org.apache.maven.cli.MavenCli.doMain(MavenCli.java:288)at
org.apache.maven.cli.MavenCli.main(MavenCli.java:199)at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)at
org.codehaus.plexus.classworlds.launcher.Launcher.launchEnhanced(Launcher.java:289)
at
org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:229)
[GitHub] Wayne1c opened a new pull request #239: KYLIN-3567 Change scala dependency scope to provided
Wayne1c opened a new pull request #239: KYLIN-3567 Change scala dependency scope to provided URL: https://github.com/apache/kylin/pull/239 This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org With regards, Apache Git Services
Re: Re: ***UNCHECKED*** apache-kylin-2.4.1-source-release源码编译错误
JAVA version
$ java -version
java version "1.8.0_131"
Java(TM) SE Runtime Environment (build 1.8.0_131-b11)
Java HotSpot(TM) 64-Bit Server VM (build 25.131-b11, mixed mode)
pom.xml
1.8
3.3.9
UTF-8
UTF-8
zhengyangju...@163.com
发件人： Zhong, Yanghong
发送时间： 2018-09-19 17:21
收件人： dev@kylin.apache.org
主题： Re: ***UNCHECKED*** apache-kylin-2.4.1-source-release源码编译错误
Hi yangjun,
Which java version do you use for mvn? It may need java 1.8.
Best,
Yanghong Zhong
On 9/19/18, 5:17 PM, "yangz_sh" wrote:
[INFO] Apache Kylin ... SUCCESS [ 15.251
s][INFO] Apache Kylin - Calcite Overrides ... SUCCESS [
15.367 s][INFO] Apache Kylin - Core Common . SUCCESS
[ 19.785 s][INFO] Apache Kylin - Core Metadata ...
SUCCESS [ 26.025 s][INFO] Apache Kylin - Core Dictionary
. SUCCESS [ 15.878 s][INFO] Apache Kylin - Core Cube
... SUCCESS [ 20.138 s][INFO] Apache Kylin - Core
Metrics SUCCESS [ 6.857 s][INFO] Apache Kylin -
Core Job SUCCESS [ 12.018 s][INFO] Apache Kylin
- Core Storage SUCCESS [ 13.219 s][INFO] Apache
Kylin - MapReduce Engine SUCCESS [ 22.492 s][INFO]
Apache Kylin - HBase Storage ... SUCCESS [ 26.064
s][INFO] Apache Kylin - Spark Engine FAILURE [
9.034 s][INFO] Apache Kylin - Hive Source .
SKIPPED[INFO] Apache Kylin - Kafka Source
SKIPPED[INFO] Apache Kylin - Query ...
SKIPPED[INFO] Apache Kylin - Metrics Reporter Hive ...
SKIPPED[INFO] Apache Kylin - Metrics Reporter Kafka ..
SKIPPED[INFO] Apache Kylin - REST Server Base
SKIPPED[INFO] Apache Kylin - REST Server .
SKIPPED[INFO] Apache Kylin - JDBC Driver .
SKIPPED[INFO] Apache Kylin - Assembly
SKIPPED[INFO] Apache Kylin - Tool
SKIPPED[INFO] Apache Kylin - Tool Assembly ...
SKIPPED[INFO] Apache Kylin - Integration Test
SKIPPED[INFO] Apache Kylin - Tomcat Extension
SKIPPED[INFO]
[INFO]
BUILD FAILURE[INFO]
[INFO]
Total time: 03:23 min[INFO] Finished at: 2018-09-19T17:16:15+08:00[INFO]
Final Memory: 54M/261M[INFO]
[ERROR]
Failed to execute goal
org.apache.maven.plugins:maven-remote-resources-plugin:1.5:process
(process-resource-bundles) on project kylin-engine-spark: Execution
process-resource-bundles of goal
org.apache.maven.plugins:maven-remote-resources-plugin:1.5:process failed:
For artifact {null:null:null:jar}: The groupId cannot be empty. -> [Help
1]org.apache.maven.lifecycle.LifecycleExecutionException: Failed to execute
goal org.apache.maven.plugins:maven-remote-resources-plugin:1.5:process
(process-resource-bundles) on project kylin-engine-spark: Execution
process-resource-bundles of goal
org.apache.maven.plugins:maven-remote-resources-plugin:1.5:process failed:
For artifact {null:null:null:jar}: The groupId cannot be empty.at
org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:212)
at
org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:153)
at
org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:145)
at
org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:116)
at
org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:80)
at
org.apache.maven.lifecycle.internal.builder.singlethreaded.SingleThreadedBuilder.build(SingleThreadedBuilder.java:51)
at
org.apache.maven.lifecycle.internal.LifecycleStarter.execute(LifecycleStarter.java:128)
at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:307)at
org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:193)at
org.apache.maven.DefaultMaven.execute(DefaultMaven.java:106)at
org.apache.maven.cli.MavenCli.execute(MavenCli.java:863)at
org.apache.maven.cli.MavenCli.doMain(MavenCli.java:288)at
org.apache.maven.cli.MavenCli.main(MavenCli.java:199)at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)at
[GitHub] asfgit commented on issue #239: KYLIN-3567 Change scala dependency scope to provided
asfgit commented on issue #239: KYLIN-3567 Change scala dependency scope to provided URL: https://github.com/apache/kylin/pull/239#issuecomment-422725586 Can one of the admins verify this patch? This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org With regards, Apache Git Services
[GitHub] asfgit commented on issue #239: KYLIN-3567 Change scala dependency scope to provided
asfgit commented on issue #239: KYLIN-3567 Change scala dependency scope to provided URL: https://github.com/apache/kylin/pull/239#issuecomment-422725585 Can one of the admins verify this patch? This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org With regards, Apache Git Services
Re: Re: ***UNCHECKED*** apache-kylin-2.4.1-source-release源码编译错误
[INFO] Apache Kylin ... SUCCESS [ 15.251 s]
[INFO] Apache Kylin - Calcite Overrides ... SUCCESS [ 15.367 s]
[INFO] Apache Kylin - Core Common . SUCCESS [ 19.785 s]
[INFO] Apache Kylin - Core Metadata ... SUCCESS [ 26.025 s]
[INFO] Apache Kylin - Core Dictionary . SUCCESS [ 15.878 s]
[INFO] Apache Kylin - Core Cube ... SUCCESS [ 20.138 s]
[INFO] Apache Kylin - Core Metrics SUCCESS [ 6.857 s]
[INFO] Apache Kylin - Core Job SUCCESS [ 12.018 s]
[INFO] Apache Kylin - Core Storage SUCCESS [ 13.219 s]
[INFO] Apache Kylin - MapReduce Engine SUCCESS [ 22.492 s]
[INFO] Apache Kylin - HBase Storage ... SUCCESS [ 26.064 s]
[INFO] Apache Kylin - Spark Engine FAILURE [ 9.034 s]
[INFO] Apache Kylin - Hive Source . SKIPPED
[INFO] Apache Kylin - Kafka Source SKIPPED
[INFO] Apache Kylin - Query ... SKIPPED
[INFO] Apache Kylin - Metrics Reporter Hive ... SKIPPED
[INFO] Apache Kylin - Metrics Reporter Kafka .. SKIPPED
[INFO] Apache Kylin - REST Server Base SKIPPED
[INFO] Apache Kylin - REST Server . SKIPPED
[INFO] Apache Kylin - JDBC Driver . SKIPPED
[INFO] Apache Kylin - Assembly SKIPPED
[INFO] Apache Kylin - Tool SKIPPED
[INFO] Apache Kylin - Tool Assembly ... SKIPPED
[INFO] Apache Kylin - Integration Test SKIPPED
[INFO] Apache Kylin - Tomcat Extension SKIPPED
[INFO]
[INFO] BUILD FAILURE
[INFO]
[INFO] Total time: 03:23 min
[INFO] Finished at: 2018-09-19T17:16:15+08:00
[INFO] Final Memory: 54M/261M
[INFO]
[ERROR] Failed to execute goal
org.apache.maven.plugins:maven-remote-resources-plugin:1.5:process
(process-resource-bundles) on project kylin-engine-spark: Execution
process-resource-bundles of goal
org.apache.maven.plugins:maven-remote-resources-plugin:1.5:process failed: For
artifact {null:null:null:jar}: The groupId cannot be empty. -> [Help 1]
org.apache.maven.lifecycle.LifecycleExecutionException: Failed to execute goal
org.apache.maven.plugins:maven-remote-resources-plugin:1.5:process
(process-resource-bundles) on project kylin-engine-spark: Execution
process-resource-bundles of goal
org.apache.maven.plugins:maven-remote-resources-plugin:1.5:process failed: For
artifact {null:null:null:jar}: The groupId cannot be empty.
at
org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:212)
at
org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:153)
at
org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:145)
at
org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:116)
at
org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:80)
at
org.apache.maven.lifecycle.internal.builder.singlethreaded.SingleThreadedBuilder.build(SingleThreadedBuilder.java:51)
at
org.apache.maven.lifecycle.internal.LifecycleStarter.execute(LifecycleStarter.java:128)
at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:307)
at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:193)
at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:106)
at org.apache.maven.cli.MavenCli.execute(MavenCli.java:863)
at org.apache.maven.cli.MavenCli.doMain(MavenCli.java:288)
at org.apache.maven.cli.MavenCli.main(MavenCli.java:199)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at
org.codehaus.plexus.classworlds.launcher.Launcher.launchEnhanced(Launcher.java:289)
at
org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:229)
at
org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:415)
at
org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:356)
Caused by: org.apache.maven.plugin.PluginExecutionException: Execution
process-resource-bundles of goal
org.apache.maven.plugins:maven-remote-resources-plugin:1.5:process failed: For
artifact
Re: ***UNCHECKED*** apache-kylin-2.4.1-source-release源码编译错误
My Environment. [INFO] Reactor Summary: [INFO] [INFO] Apache Kylin 2.4.1 . SUCCESS [ 2.934 s] [INFO] Apache Kylin - Calcite Overrides ... SUCCESS [ 4.848 s] [INFO] Apache Kylin - Core Common . SUCCESS [ 5.619 s] [INFO] Apache Kylin - Core Metadata ... SUCCESS [ 8.432 s] [INFO] Apache Kylin - Core Dictionary . SUCCESS [ 4.302 s] [INFO] Apache Kylin - Core Cube ... SUCCESS [ 7.044 s] [INFO] Apache Kylin - Core Metrics SUCCESS [ 2.536 s] [INFO] Apache Kylin - Core Job SUCCESS [ 3.757 s] [INFO] Apache Kylin - Core Storage SUCCESS [ 3.543 s] [INFO] Apache Kylin - MapReduce Engine SUCCESS [ 7.757 s] [INFO] Apache Kylin - HBase Storage ... SUCCESS [ 11.192 s] [INFO] Apache Kylin - Spark Engine SUCCESS [ 10.194 s] [INFO] Apache Kylin - Hive Source . SUCCESS [ 7.301 s] [INFO] Apache Kylin - Kafka Source SUCCESS [ 5.532 s] [INFO] Apache Kylin - Query ... SUCCESS [ 8.240 s] [INFO] Apache Kylin - Metrics Reporter Hive ... SUCCESS [ 6.497 s] [INFO] Apache Kylin - Metrics Reporter Kafka .. SUCCESS [ 4.755 s] [INFO] Apache Kylin - REST Server Base SUCCESS [01:19 min] [INFO] Apache Kylin - REST Server . SUCCESS [ 31.784 s] [INFO] Apache Kylin - JDBC Driver . SUCCESS [ 6.399 s] [INFO] Apache Kylin - Assembly SUCCESS [ 3.787 s] [INFO] Apache Kylin - Tool SUCCESS [ 17.275 s] [INFO] Apache Kylin - Tool Assembly ... SUCCESS [ 2.937 s] [INFO] Apache Kylin - Integration Test SUCCESS [ 15.029 s] [INFO] Apache Kylin - Tomcat Extension 2.4.1 .. SUCCESS [ 2.726 s] [INFO] [INFO] BUILD SUCCESS [INFO] [INFO] Total time: 04:23 min [INFO] Finished at: 2018-09-19T18:00:11+08:00 [INFO] LM-SHC-16501214:apache-kylin-2.4.1 yangzhong$ mvn -v Apache Maven 3.5.4 (1edded0938998edf8bf061f1ceb3cfdeccf443fe; 2018-06-18T02:33:14+08:00) Maven home: /Users/yangzhong/Software/apache-maven-3.5.4 Java version: 1.8.0_66, vendor: Oracle Corporation, runtime: /Library/Java/JavaVirtualMachines/jdk1.8.0_66.jdk/Contents/Home/jre Default locale: en_US, platform encoding: UTF-8 OS name: "mac os x", version: "10.11.6", arch: "x86_64", family: "mac" --- On 9/19/18, 5:29 PM, "zhengyangju...@163.com" wrote: [INFO] Apache Kylin ... SUCCESS [ 15.251 s] [INFO] Apache Kylin - Calcite Overrides ... SUCCESS [ 15.367 s] [INFO] Apache Kylin - Core Common . SUCCESS [ 19.785 s] [INFO] Apache Kylin - Core Metadata ... SUCCESS [ 26.025 s] [INFO] Apache Kylin - Core Dictionary . SUCCESS [ 15.878 s] [INFO] Apache Kylin - Core Cube ... SUCCESS [ 20.138 s] [INFO] Apache Kylin - Core Metrics SUCCESS [ 6.857 s] [INFO] Apache Kylin - Core Job SUCCESS [ 12.018 s] [INFO] Apache Kylin - Core Storage SUCCESS [ 13.219 s] [INFO] Apache Kylin - MapReduce Engine SUCCESS [ 22.492 s] [INFO] Apache Kylin - HBase Storage ... SUCCESS [ 26.064 s] [INFO] Apache Kylin - Spark Engine FAILURE [ 9.034 s] [INFO] Apache Kylin - Hive Source . SKIPPED [INFO] Apache Kylin - Kafka Source SKIPPED [INFO] Apache Kylin - Query ... SKIPPED [INFO] Apache Kylin - Metrics Reporter Hive ... SKIPPED [INFO] Apache Kylin - Metrics Reporter Kafka .. SKIPPED [INFO] Apache Kylin - REST Server Base SKIPPED [INFO] Apache Kylin - REST Server . SKIPPED [INFO] Apache Kylin - JDBC Driver . SKIPPED [INFO] Apache Kylin - Assembly SKIPPED [INFO] Apache Kylin - Tool SKIPPED [INFO] Apache Kylin - Tool Assembly ... SKIPPED [INFO] Apache Kylin - Integration Test
[jira] [Created] (KYLIN-3570) Automatically build system cube
Yichen Zhou created KYLIN-3570: -- Summary: Automatically build system cube Key: KYLIN-3570 URL: https://issues.apache.org/jira/browse/KYLIN-3570 Project: Kylin Issue Type: Improvement Components: Metrics Reporter: Yichen Zhou Users have to do some configurations and run scripts to build system cube. It is better to make these opreations easy and simple. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
