[GitHub] [kylin] coveralls commented on issue #615: KYLIN-3958 MrHive-Dict support build by livy
coveralls commented on issue #615: KYLIN-3958 MrHive-Dict support build by livy URL: https://github.com/apache/kylin/pull/615#issuecomment-485346569 ## Pull Request Test Coverage Report for [Build 4411](https://coveralls.io/builds/22942556) * **0** of **42** **(0.0%)** changed or added relevant lines in **5** files are covered. * **2** unchanged lines in **2** files lost coverage. * Overall coverage decreased (**-0.0008%**) to **27.823%** --- | Changes Missing Coverage | Covered Lines | Changed/Added Lines | % | | :-|--||---: | | [core-common/src/main/java/org/apache/kylin/common/util/HiveCmdBuilder.java](https://coveralls.io/builds/22942556/source?filename=core-common%2Fsrc%2Fmain%2Fjava%2Forg%2Fapache%2Fkylin%2Fcommon%2Futil%2FHiveCmdBuilder.java#L142) | 0 | 1 | 0.0% | [source-hive/src/main/java/org/apache/kylin/source/hive/RedistributeFlatHiveTableByLivyStep.java](https://coveralls.io/builds/22942556/source?filename=source-hive%2Fsrc%2Fmain%2Fjava%2Forg%2Fapache%2Fkylin%2Fsource%2Fhive%2FRedistributeFlatHiveTableByLivyStep.java#L53) | 0 | 2 | 0.0% | [source-hive/src/main/java/org/apache/kylin/source/hive/CreateFlatHiveTableByLivyStep.java](https://coveralls.io/builds/22942556/source?filename=source-hive%2Fsrc%2Fmain%2Fjava%2Forg%2Fapache%2Fkylin%2Fsource%2Fhive%2FCreateFlatHiveTableByLivyStep.java#L41) | 0 | 4 | 0.0% | [source-hive/src/main/java/org/apache/kylin/source/hive/CreateMrHiveDictStep.java](https://coveralls.io/builds/22942556/source?filename=source-hive%2Fsrc%2Fmain%2Fjava%2Forg%2Fapache%2Fkylin%2Fsource%2Fhive%2FCreateMrHiveDictStep.java#L129) | 0 | 8 | 0.0% | [source-hive/src/main/java/org/apache/kylin/source/hive/MRHiveDictUtil.java](https://coveralls.io/builds/22942556/source?filename=source-hive%2Fsrc%2Fmain%2Fjava%2Forg%2Fapache%2Fkylin%2Fsource%2Fhive%2FMRHiveDictUtil.java#L46) | 0 | 27 | 0.0% | Files with Coverage Reduction | New Missed Lines | % | | :-|--|--: | | [source-hive/src/main/java/org/apache/kylin/source/hive/RedistributeFlatHiveTableByLivyStep.java](https://coveralls.io/builds/22942556/source?filename=source-hive%2Fsrc%2Fmain%2Fjava%2Forg%2Fapache%2Fkylin%2Fsource%2Fhive%2FRedistributeFlatHiveTableByLivyStep.java#L56) | 1 | 0.0% | | [source-hive/src/main/java/org/apache/kylin/source/hive/CreateFlatHiveTableByLivyStep.java](https://coveralls.io/builds/22942556/source?filename=source-hive%2Fsrc%2Fmain%2Fjava%2Forg%2Fapache%2Fkylin%2Fsource%2Fhive%2FCreateFlatHiveTableByLivyStep.java#L45) | 1 | 0.0% | | Totals | [![Coverage Status](https://coveralls.io/builds/22942556/badge)](https://coveralls.io/builds/22942556) | | :-- | --: | | Change from base [Build 4405](https://coveralls.io/builds/22907851): | -0.0008% | | Covered Lines: | 22756 | | Relevant Lines: | 81787 | --- # đ - [Coveralls](https://coveralls.io) This is an automated message from the Apache Git Service. To respond to the message, please log on to 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] [kylin] codecov-io commented on issue #615: KYLIN-3958 MrHive-Dict support build by livy
codecov-io commented on issue #615: KYLIN-3958 MrHive-Dict support build by livy URL: https://github.com/apache/kylin/pull/615#issuecomment-485347555 # [Codecov](https://codecov.io/gh/apache/kylin/pull/615?src=pr&el=h1) Report > Merging [#615](https://codecov.io/gh/apache/kylin/pull/615?src=pr&el=desc) into [master](https://codecov.io/gh/apache/kylin/commit/426a22711d6e25d2b7a4c1c3c6cea4e642b7f248?src=pr&el=desc) will **decrease** coverage by `<.01%`. > The diff coverage is `0%`. [![Impacted file tree graph](https://codecov.io/gh/apache/kylin/pull/615/graphs/tree.svg?width=650&token=JawVgbgsVo&height=150&src=pr)](https://codecov.io/gh/apache/kylin/pull/615?src=pr&el=tree) ```diff @@ Coverage Diff @@ ## master #615 +/- ## - Coverage 25.34% 25.34% -0.01% - Complexity 5840 5841 +1 Files 1379 1379 Lines 8178181787 +6 Branches 1145711459 +2 - Hits 2073120730 -1 - Misses5902859035 +7 Partials 2022 2022 ``` | [Impacted Files](https://codecov.io/gh/apache/kylin/pull/615?src=pr&el=tree) | Coverage Π| Complexity Π| | |---|---|---|---| | [...urce/hive/RedistributeFlatHiveTableByLivyStep.java](https://codecov.io/gh/apache/kylin/pull/615/diff?src=pr&el=tree#diff-c291cmNlLWhpdmUvc3JjL21haW4vamF2YS9vcmcvYXBhY2hlL2t5bGluL3NvdXJjZS9oaXZlL1JlZGlzdHJpYnV0ZUZsYXRIaXZlVGFibGVCeUxpdnlTdGVwLmphdmE=) | `0% <0%> (ø)` | `0 <0> (ø)` | :arrow_down: | | [...lin/source/hive/CreateFlatHiveTableByLivyStep.java](https://codecov.io/gh/apache/kylin/pull/615/diff?src=pr&el=tree#diff-c291cmNlLWhpdmUvc3JjL21haW4vamF2YS9vcmcvYXBhY2hlL2t5bGluL3NvdXJjZS9oaXZlL0NyZWF0ZUZsYXRIaXZlVGFibGVCeUxpdnlTdGVwLmphdmE=) | `0% <0%> (ø)` | `0 <0> (ø)` | :arrow_down: | | [...a/org/apache/kylin/common/util/HiveCmdBuilder.java](https://codecov.io/gh/apache/kylin/pull/615/diff?src=pr&el=tree#diff-Y29yZS1jb21tb24vc3JjL21haW4vamF2YS9vcmcvYXBhY2hlL2t5bGluL2NvbW1vbi91dGlsL0hpdmVDbWRCdWlsZGVyLmphdmE=) | `81.08% <0%> (-1.12%)` | `12 <0> (ø)` | | | [...apache/kylin/source/hive/CreateMrHiveDictStep.java](https://codecov.io/gh/apache/kylin/pull/615/diff?src=pr&el=tree#diff-c291cmNlLWhpdmUvc3JjL21haW4vamF2YS9vcmcvYXBhY2hlL2t5bGluL3NvdXJjZS9oaXZlL0NyZWF0ZU1ySGl2ZURpY3RTdGVwLmphdmE=) | `0% <0%> (ø)` | `0 <0> (ø)` | :arrow_down: | | [...a/org/apache/kylin/source/hive/MRHiveDictUtil.java](https://codecov.io/gh/apache/kylin/pull/615/diff?src=pr&el=tree#diff-c291cmNlLWhpdmUvc3JjL21haW4vamF2YS9vcmcvYXBhY2hlL2t5bGluL3NvdXJjZS9oaXZlL01SSGl2ZURpY3RVdGlsLmphdmE=) | `0% <0%> (ø)` | `0 <0> (ø)` | :arrow_down: | | [.../apache/kylin/cube/cuboid/TreeCuboidScheduler.java](https://codecov.io/gh/apache/kylin/pull/615/diff?src=pr&el=tree#diff-Y29yZS1jdWJlL3NyYy9tYWluL2phdmEvb3JnL2FwYWNoZS9reWxpbi9jdWJlL2N1Ym9pZC9UcmVlQ3Vib2lkU2NoZWR1bGVyLmphdmE=) | `63.84% <0%> (-2.31%)` | `0% <0%> (ø)` | | | [...he/kylin/dict/lookup/cache/RocksDBLookupTable.java](https://codecov.io/gh/apache/kylin/pull/615/diff?src=pr&el=tree#diff-Y29yZS1kaWN0aW9uYXJ5L3NyYy9tYWluL2phdmEvb3JnL2FwYWNoZS9reWxpbi9kaWN0L2xvb2t1cC9jYWNoZS9Sb2Nrc0RCTG9va3VwVGFibGUuamF2YQ==) | `78.37% <0%> (+5.4%)` | `7% <0%> (+1%)` | :arrow_up: | -- [Continue to review full report at Codecov](https://codecov.io/gh/apache/kylin/pull/615?src=pr&el=continue). > **Legend** - [Click here to learn more](https://docs.codecov.io/docs/codecov-delta) > `Π= absolute (impact)`, `ø = not affected`, `? = missing data` > Powered by [Codecov](https://codecov.io/gh/apache/kylin/pull/615?src=pr&el=footer). Last update [426a227...5b61019](https://codecov.io/gh/apache/kylin/pull/615?src=pr&el=lastupdated). Read the [comment docs](https://docs.codecov.io/docs/pull-request-comments). This is an automated message from the Apache Git Service. To respond to the message, please log on to 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] [kylin] nichunen commented on issue #614: Fixed use customized precision
nichunen commented on issue #614: Fixed use customized precision URL: https://github.com/apache/kylin/pull/614#issuecomment-485395798 @majic31 Hi, thanks for contributing. Could you open a jira issue for this? By the way, commit message in Chinese is not recommended This is an automated message from the Apache Git Service. To respond to the message, please log on to 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] [kylin] nichunen commented on a change in pull request #611: KYLIN-3943 Fix some problems in system-cube.sh
nichunen commented on a change in pull request #611: KYLIN-3943 Fix some problems in system-cube.sh URL: https://github.com/apache/kylin/pull/611#discussion_r277295120 ## File path: build/bin/system-cube.sh ## @@ -53,7 +66,12 @@ elif [ "$1" == "setup" ] then #creat SCSinkTools.json SINK_TOOLS_FILE=$KYLIN_HOME/SCSinkTools.json - cat <<- EOF > ${SINK_TOOLS_FILE} + + echo "setup system cubes" + + rm -rf $SINK_TOOLS_FILE $OUTPUT_FORDER Review comment: will the script stopped if no file $OUTPUT_FORDER existed? This is an automated message from the Apache Git Service. To respond to the message, please log on to 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] [kylin] nichunen commented on a change in pull request #611: KYLIN-3943 Fix some problems in system-cube.sh
nichunen commented on a change in pull request #611: KYLIN-3943 Fix some problems in system-cube.sh URL: https://github.com/apache/kylin/pull/611#discussion_r277294926 ## File path: build/bin/system-cube.sh ## @@ -80,20 +98,21 @@ then #refresh signature $KYLIN_HOME/bin/kylin.sh org.apache.kylin.cube.cli.CubeSignatureRefresher ${SC_NAME_1},${SC_NAME_2},${SC_NAME_3},${SC_NAME_4},${SC_NAME_5} Review comment: seems not well-formatted This is an automated message from the Apache Git Service. To respond to the message, please log on to 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
[jira] [Created] (KYLIN-3965) When using DriverManager - No suitable driver found for jdbc:kylin://
Alexander created KYLIN-3965: Summary: When using DriverManager - No suitable driver found for jdbc:kylin:// Key: KYLIN-3965 URL: https://issues.apache.org/jira/browse/KYLIN-3965 Project: Kylin Issue Type: Bug Components: Driver - JDBC Affects Versions: v2.6.1 Reporter: Alexander Assignee: Alexander Caused by: java.sql.SQLException: No suitable driver found for jdbc:kylin:// Â This is because META-INF/services/java.sql.Driver got incorrect name org.apache.calcite.avatica.remote.Driver -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (KYLIN-3965) When using DriverManager - No suitable driver found for jdbc:kylin://
[ https://issues.apache.org/jira/browse/KYLIN-3965?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alexander updated KYLIN-3965: - Attachment: KYLIN-3965.master.001.patch > When using DriverManager - No suitable driver found for jdbc:kylin:// > - > > Key: KYLIN-3965 > URL: https://issues.apache.org/jira/browse/KYLIN-3965 > Project: Kylin > Issue Type: Bug > Components: Driver - JDBC >Affects Versions: v2.6.1 >Reporter: Alexander >Assignee: Alexander >Priority: Minor > Attachments: KYLIN-3965.master.001.patch > > > Caused by: java.sql.SQLException: No suitable driver found for jdbc:kylin:// > Â > This is because META-INF/services/java.sql.Driver got incorrect name > org.apache.calcite.avatica.remote.Driver -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[GitHub] [kylin] Sidonet opened a new pull request #616: KYLIN-3965 JDBC fix.
Sidonet opened a new pull request #616: KYLIN-3965 JDBC fix. URL: https://github.com/apache/kylin/pull/616 - Driver manager compability. - Add guava to uber-jar for standalone usage. This is an automated message from the Apache Git Service. To respond to the message, please log on to 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] [kylin] asfgit commented on issue #616: KYLIN-3965 JDBC fix.
asfgit commented on issue #616: KYLIN-3965 JDBC fix. URL: https://github.com/apache/kylin/pull/616#issuecomment-485434205 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 to 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
[jira] [Commented] (KYLIN-3965) When using DriverManager - No suitable driver found for jdbc:kylin://
[ https://issues.apache.org/jira/browse/KYLIN-3965?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16823138#comment-16823138 ] ASF GitHub Bot commented on KYLIN-3965: --- Sidonet commented on pull request #616: KYLIN-3965 JDBC fix. URL: https://github.com/apache/kylin/pull/616 - Driver manager compability. - Add guava to uber-jar for standalone usage. This is an automated message from the Apache Git Service. To respond to the message, please log on to 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 > When using DriverManager - No suitable driver found for jdbc:kylin:// > - > > Key: KYLIN-3965 > URL: https://issues.apache.org/jira/browse/KYLIN-3965 > Project: Kylin > Issue Type: Bug > Components: Driver - JDBC >Affects Versions: v2.6.1 >Reporter: Alexander >Assignee: Alexander >Priority: Minor > Attachments: KYLIN-3965.master.001.patch > > > Caused by: java.sql.SQLException: No suitable driver found for jdbc:kylin:// > Â > This is because META-INF/services/java.sql.Driver got incorrect name > org.apache.calcite.avatica.remote.Driver -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[GitHub] [kylin] Sidonet commented on issue #616: KYLIN-3965 JDBC fix.
Sidonet commented on issue #616: KYLIN-3965 JDBC fix. URL: https://github.com/apache/kylin/pull/616#issuecomment-485436078 ![image](https://user-images.githubusercontent.com/39062077/56505829-64274000-6525-11e9-8ed6-ac37ee86f7df.png) Tested on external project, with only kylin-jdbc.jar in dependicies This is an automated message from the Apache Git Service. To respond to the message, please log on to 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] [kylin] coveralls commented on issue #616: KYLIN-3965 JDBC fix.
coveralls commented on issue #616: KYLIN-3965 JDBC fix. URL: https://github.com/apache/kylin/pull/616#issuecomment-485441186 ## Pull Request Test Coverage Report for [Build 4412](https://coveralls.io/builds/22948168) * **0** of **0** changed or added relevant lines in **0** files are covered. * **3** unchanged lines in **2** files lost coverage. * Overall coverage decreased (**-0.004%**) to **27.821%** --- | Files with Coverage Reduction | New Missed Lines | % | | :-|--|--: | | [core-cube/src/main/java/org/apache/kylin/cube/inmemcubing/MemDiskStore.java](https://coveralls.io/builds/22948168/source?filename=core-cube%2Fsrc%2Fmain%2Fjava%2Forg%2Fapache%2Fkylin%2Fcube%2Finmemcubing%2FMemDiskStore.java#L553) | 1 | 78.12% | | [core-job/src/main/java/org/apache/kylin/job/impl/threadpool/DefaultScheduler.java](https://coveralls.io/builds/22948168/source?filename=core-job%2Fsrc%2Fmain%2Fjava%2Forg%2Fapache%2Fkylin%2Fjob%2Fimpl%2Fthreadpool%2FDefaultScheduler.java#L194) | 2 | 80.23% | | Totals | [![Coverage Status](https://coveralls.io/builds/22948168/badge)](https://coveralls.io/builds/22948168) | | :-- | --: | | Change from base [Build 4405](https://coveralls.io/builds/22907851): | -0.004% | | Covered Lines: | 22752 | | Relevant Lines: | 81781 | --- # đ - [Coveralls](https://coveralls.io) This is an automated message from the Apache Git Service. To respond to the message, please log on to 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] [kylin] nichunen merged pull request #610: KYLIN-3960, Only update user when login in LDAP environment
nichunen merged pull request #610: KYLIN-3960, Only update user when login in LDAP environment URL: https://github.com/apache/kylin/pull/610 This is an automated message from the Apache Git Service. To respond to the message, please log on to 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
[jira] [Commented] (KYLIN-3960) Only update user when login in LDAP environment
[ https://issues.apache.org/jira/browse/KYLIN-3960?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16823166#comment-16823166 ] ASF GitHub Bot commented on KYLIN-3960: --- nichunen commented on pull request #610: KYLIN-3960, Only update user when login in LDAP environment URL: https://github.com/apache/kylin/pull/610 This is an automated message from the Apache Git Service. To respond to the message, please log on to 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 > Only update user when login in LDAP environment > --- > > Key: KYLIN-3960 > URL: https://issues.apache.org/jira/browse/KYLIN-3960 > Project: Kylin > Issue Type: Improvement > Components: Security >Reporter: Jiatao Tao >Assignee: Jiatao Tao >Priority: Minor > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (KYLIN-3960) Only update user when login in LDAP environment
[ https://issues.apache.org/jira/browse/KYLIN-3960?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16823165#comment-16823165 ] ASF subversion and git services commented on KYLIN-3960: Commit 261de78b8adbb7ce96a34afccd322de144a70fc7 in kylin's branch refs/heads/master from Jiatao Tao [ https://gitbox.apache.org/repos/asf?p=kylin.git;h=261de78 ] KYLIN-3960, Only update user when login in LDAP environment > Only update user when login in LDAP environment > --- > > Key: KYLIN-3960 > URL: https://issues.apache.org/jira/browse/KYLIN-3960 > Project: Kylin > Issue Type: Improvement > Components: Security >Reporter: Jiatao Tao >Assignee: Jiatao Tao >Priority: Minor > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[GitHub] [kylin] majic31 commented on issue #614: Fixed use customized precision
majic31 commented on issue #614: Fixed use customized precision URL: https://github.com/apache/kylin/pull/614#issuecomment-485450603 @nichunen Thank you for reply. It's my first pull request in github, so I make some mistakes about the routines, sorry~ So should I open a jira issue and pull request again? (I've never use jira before, would you like to give me some help about using it?) This is an automated message from the Apache Git Service. To respond to the message, please log on to 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
[jira] [Created] (KYLIN-3966) Metric multiplication and metric division not working in query
Gladson Vas created KYLIN-3966: -- Summary: Metric multiplication and metric division not working in query Key: KYLIN-3966 URL: https://issues.apache.org/jira/browse/KYLIN-3966 Project: Kylin Issue Type: Bug Components: Query Engine Reporter: Gladson Vas When i try to multiply or divide 2 metric columns in a query eg: select col1*col2 from table select col1/col2 from table. it throws the following errors That both of the two sides of the BinaryTupleExpression own columns is not supported for * while executing SQL That both of the two sides of the BinaryTupleExpression own columns is not supported for / while executing SQL. But when i use the + or - operators in the query it seems to be working fine. Is there any way to support these 2 operators as well? Thanks, Gladson  -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (KYLIN-3966) Metric multiplication and metric division not working in query
[ https://issues.apache.org/jira/browse/KYLIN-3966?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gladson Vas updated KYLIN-3966: --- Priority: Blocker (was: Major) > Metric multiplication and metric division not working in query > -- > > Key: KYLIN-3966 > URL: https://issues.apache.org/jira/browse/KYLIN-3966 > Project: Kylin > Issue Type: Bug > Components: Query Engine >Reporter: Gladson Vas >Priority: Blocker > > When i try to multiply or divide 2 metric columns in a query > eg: select col1*col2 from table > select col1/col2 from table. > it throws the following errors > That both of the two sides of the BinaryTupleExpression own columns is not > supported for * while executing SQL > That both of the two sides of the BinaryTupleExpression own columns is not > supported for / while executing SQL. > But when i use the + or - operators in the query it seems to be working fine. > Is there any way to support these 2 operators as well? > Thanks, > Gladson >  -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Created] (KYLIN-3967) sum along with case expression does not work in query
Gladson Vas created KYLIN-3967: -- Summary: sum along with case expression does not work in query Key: KYLIN-3967 URL: https://issues.apache.org/jira/browse/KYLIN-3967 Project: Kylin Issue Type: Bug Components: Query Engine Reporter: Gladson Vas When i try to run a query with a sum case expression combination, eg: select sum(case when col1<0 then 0 else col1 end ) from table i get the following error: No realization found for OLAPContext, CUBE_UNMATCHED_AGGREGATION[FunctionDesc [expression=SUM, parameter=CASE(<($8, 0), 0, $8), returnType=null]], rel#36838:OLAPTableScan.OLAP.[](table=[DEFAULT, table],ctx=,fields=[0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106]) while executing SQL: "select sum (case when col1 <0 then 0 else col1 end ) from table LIMIT 5"  is there any way to support this sum case expression in the query engine? Also I get the same error when the sum operation is done on a column derived from a case expression in a subquery. eg: select sum(a.col1) from (select case when col1<0 then 0 else col1 end as col1 from table) a Thanks, Gladson  -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Created] (KYLIN-3968) Customized precision doesn't work in web
Jack created KYLIN-3968: --- Summary: Customized precision doesn't work in web Key: KYLIN-3968 URL: https://issues.apache.org/jira/browse/KYLIN-3968 Project: Kylin Issue Type: Bug Components: Web Affects Versions: v2.6.1 Reporter: Jack Fix For: v2.6.1 In the cubeMeasures.js, It will withdraw precision and scale by using Regular Expression. The scale parameter is ok, but precision use the magic number 19. So we fixed it, In cubeMeasures.js, around line 469: âvar precision = 19;â --> "var precision = returnValue[2] || 0;" and we test ok including building cube and querying when the column is decimal(38,18). -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[GitHub] [kylin] majic31 commented on issue #614: Fixed use customized precision
majic31 commented on issue #614: Fixed use customized precision URL: https://github.com/apache/kylin/pull/614#issuecomment-485618073 I create issue https://issues.apache.org/jira/browse/KYLIN-3968. This is an automated message from the Apache Git Service. To respond to the message, please log on to 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] [kylin] nichunen commented on a change in pull request #611: KYLIN-3943 Fix some problems in system-cube.sh
nichunen commented on a change in pull request #611: KYLIN-3943 Fix some problems in system-cube.sh URL: https://github.com/apache/kylin/pull/611#discussion_r277294926 ## File path: build/bin/system-cube.sh ## @@ -80,20 +98,21 @@ then #refresh signature $KYLIN_HOME/bin/kylin.sh org.apache.kylin.cube.cli.CubeSignatureRefresher ${SC_NAME_1},${SC_NAME_2},${SC_NAME_3},${SC_NAME_4},${SC_NAME_5} Review comment: seems not well-formatted This is an automated message from the Apache Git Service. To respond to the message, please log on to 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] [kylin] nichunen commented on a change in pull request #611: KYLIN-3943 Fix some problems in system-cube.sh
nichunen commented on a change in pull request #611: KYLIN-3943 Fix some problems in system-cube.sh URL: https://github.com/apache/kylin/pull/611#discussion_r277295120 ## File path: build/bin/system-cube.sh ## @@ -53,7 +66,12 @@ elif [ "$1" == "setup" ] then #creat SCSinkTools.json SINK_TOOLS_FILE=$KYLIN_HOME/SCSinkTools.json - cat <<- EOF > ${SINK_TOOLS_FILE} + + echo "setup system cubes" + + rm -rf $SINK_TOOLS_FILE $OUTPUT_FORDER Review comment: will the script stopped if no file $OUTPUT_FORDER existed? This is an automated message from the Apache Git Service. To respond to the message, please log on to 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
[jira] [Commented] (KYLIN-3943) system-cube.sh has some problems
[ https://issues.apache.org/jira/browse/KYLIN-3943?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16823636#comment-16823636 ] ASF subversion and git services commented on KYLIN-3943: Commit cfabb816a54855b321d9c1ac2acdb76bb7d2652a in kylin's branch refs/heads/master from chao long [ https://gitbox.apache.org/repos/asf?p=kylin.git;h=cfabb81 ] KYLIN-3943 Fix some problems in system-cube.sh > system-cube.sh has some problems > > > Key: KYLIN-3943 > URL: https://issues.apache.org/jira/browse/KYLIN-3943 > Project: Kylin > Issue Type: Bug >Reporter: Chao Long >Assignee: Chao Long >Priority: Major > Fix For: v2.6.2 > > Attachments: image-2019-04-09-18-50-35-111.png, > image-2019-04-09-23-07-19-229.png > > > 1, The name of system cube should not hard code. the suffix should get from > config. > !image-2019-04-09-18-50-35-111.png! > 2, server port should not hard code > !image-2019-04-09-23-07-19-229.png! Â -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[GitHub] [kylin] nichunen merged pull request #611: KYLIN-3943 Fix some problems in system-cube.sh
nichunen merged pull request #611: KYLIN-3943 Fix some problems in system-cube.sh URL: https://github.com/apache/kylin/pull/611 This is an automated message from the Apache Git Service. To respond to the message, please log on to 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
[jira] [Commented] (KYLIN-3943) system-cube.sh has some problems
[ https://issues.apache.org/jira/browse/KYLIN-3943?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16823635#comment-16823635 ] ASF GitHub Bot commented on KYLIN-3943: --- nichunen commented on pull request #611: KYLIN-3943 Fix some problems in system-cube.sh URL: https://github.com/apache/kylin/pull/611 This is an automated message from the Apache Git Service. To respond to the message, please log on to 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 > system-cube.sh has some problems > > > Key: KYLIN-3943 > URL: https://issues.apache.org/jira/browse/KYLIN-3943 > Project: Kylin > Issue Type: Bug >Reporter: Chao Long >Assignee: Chao Long >Priority: Major > Fix For: v2.6.2 > > Attachments: image-2019-04-09-18-50-35-111.png, > image-2019-04-09-23-07-19-229.png > > > 1, The name of system cube should not hard code. the suffix should get from > config. > !image-2019-04-09-18-50-35-111.png! > 2, server port should not hard code > !image-2019-04-09-23-07-19-229.png! Â -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Created] (KYLIN-3969) BeelineHiveClient can't parse Hive meta data result set with partitioned table
Tuo Zhu created KYLIN-3969: -- Summary: BeelineHiveClient can't parse Hive meta data result set with partitioned table Key: KYLIN-3969 URL: https://issues.apache.org/jira/browse/KYLIN-3969 Project: Kylin Issue Type: Bug Components: Metadata Affects Versions: v2.6.1 Environment: Hive 3.1.0, HiveServer2, BeelineďźAlong with Ambari 2.7.1.0) CentOS Linux release 7.6.1810 Reporter: Tuo Zhu When creating a model, you can add tables without partitions, but can't add ones with partitions. Web UI popsďź"Oops. cannot get HiveTableMeta". I tried same table in Hive2 with cli, it works. log prints: {code:java} java.lang.RuntimeException: cannot get HiveTableMeta at org.apache.kylin.source.hive.HiveMetadataExplorer.loadTableMetadata(HiveMetadataExplorer.java:68) at org.apache.kylin.rest.service.TableService.extractHiveTableMeta(TableService.java:205) at org.apache.kylin.rest.service.TableService.loadHiveTablesToProject(TableService.java:131) at org.apache.kylin.rest.controller.TableController.loadHiveTables(TableController.java:113) 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.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205) at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133) at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738) at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872) at javax.servlet.http.HttpServlet.service(HttpServlet.java:661) at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846) at javax.servlet.http.HttpServlet.service(HttpServlet.java:742) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:317) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.w
[jira] [Updated] (KYLIN-3969) BeelineHiveClient can't parse Hive meta data result set with partitioned table
[ https://issues.apache.org/jira/browse/KYLIN-3969?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Tuo Zhu updated KYLIN-3969: --- Description: When creating a model, you can add tables without partitions, but can't add ones with partitions. Web UI popsďź"Oops. cannot get HiveTableMeta". I tried same table in Hive2 with cli, it works. log prints: {code:java} java.lang.RuntimeException: cannot get HiveTableMeta at org.apache.kylin.source.hive.HiveMetadataExplorer.loadTableMetadata(HiveMetadataExplorer.java:68) at org.apache.kylin.rest.service.TableService.extractHiveTableMeta(TableService.java:205) at org.apache.kylin.rest.service.TableService.loadHiveTablesToProject(TableService.java:131) at org.apache.kylin.rest.controller.TableController.loadHiveTables(TableController.java:113) 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.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205) at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133) at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738) at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872) at javax.servlet.http.HttpServlet.service(HttpServlet.java:661) at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846) at javax.servlet.http.HttpServlet.service(HttpServlet.java:742) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:317) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:215) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.sprin
[jira] [Updated] (KYLIN-3969) BeelineHiveClient can't parse Hive meta data result set with partitioned table
[ https://issues.apache.org/jira/browse/KYLIN-3969?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Tuo Zhu updated KYLIN-3969: --- Priority: Blocker (was: Major) > BeelineHiveClient can't parse Hive meta data result set with partitioned table > -- > > Key: KYLIN-3969 > URL: https://issues.apache.org/jira/browse/KYLIN-3969 > Project: Kylin > Issue Type: Bug > Components: Metadata >Affects Versions: v2.6.1 > Environment: Hive 3.1.0, HiveServer2, BeelineďźAlong with Ambari > 2.7.1.0) > CentOS Linux release 7.6.1810 >Reporter: Tuo Zhu >Priority: Blocker > > When creating a model, you can add tables without partitions, but can't add > ones with partitions. > Web UI popsďź"Oops. cannot get HiveTableMeta". > I tried same table in Hive2 with cli, it works. > log prints: > {code:java} > java.lang.RuntimeException: cannot get HiveTableMeta > at > org.apache.kylin.source.hive.HiveMetadataExplorer.loadTableMetadata(HiveMetadataExplorer.java:68) > at > org.apache.kylin.rest.service.TableService.extractHiveTableMeta(TableService.java:205) > at > org.apache.kylin.rest.service.TableService.loadHiveTablesToProject(TableService.java:131) > at > org.apache.kylin.rest.controller.TableController.loadHiveTables(TableController.java:113) > 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.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205) > at > org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133) > at > org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97) > at > org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827) > at > org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738) > at > org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85) > at > org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967) > at > org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901) > at > org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970) > at > org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:661) > at > org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:742) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) > at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) > at > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:317) > at > org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127) > at > org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91) > at > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > at > org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114) > at > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > at > org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137) > at > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > at > org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111) > at > org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) > at > org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(Secu
[jira] [Updated] (KYLIN-3935) ZKUtil acquire the wrong Zookeeper Path on windows
[ https://issues.apache.org/jira/browse/KYLIN-3935?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] nichunen updated KYLIN-3935: Fix Version/s: (was: v2.6.2) v3.0.0 > ZKUtil acquire the wrong Zookeeper Path on windows > -- > > Key: KYLIN-3935 > URL: https://issues.apache.org/jira/browse/KYLIN-3935 > Project: Kylin > Issue Type: Bug >Affects Versions: v2.6.1 >Reporter: Na Zhai >Assignee: Na Zhai >Priority: Major > Fix For: v3.0.0 > > > In my windows env, when I run Kylin, Kylin service can't start. In class > ZKUtil, I found Kylin use File(path).getCanonicalPath() to norm windows path, > however this will get a path like ' C:\kylin\kylin_metadata'.For Zookeeper, > the path must start with / character. > {color:#FF}return new File(path).toURI().getPath(){color}Â might be > better!!! > Below is stackTrace: > : java.lang.RuntimeException: > com.google.common.util.concurrent.UncheckedExecutionException: > java.lang.RuntimeException: Fail to check or create znode for chRoot > F:\kylin\kylin_metadata_idea due to > at org.apache.kylin.common.util.ZKUtil.getZookeeperClient(ZKUtil.java:137) > at org.apache.kylin.common.util.ZKUtil.getZookeeperClient(ZKUtil.java:115) > at > org.apache.kylin.job.lock.zookeeper.ZookeeperDistributedLock$Factory.(ZookeeperDistributedLock.java:57) > at > org.apache.kylin.job.lock.zookeeper.ZookeeperDistributedLock$Factory.(ZookeeperDistributedLock.java:53) > at > org.apache.kylin.job.lock.zookeeper.ZookeeperJobLock.(ZookeeperJobLock.java:32) > at > org.apache.kylin.rest.service.JobService.afterPropertiesSet(JobService.java:132) > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1687) > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1624) > ... 61 more > Caused by: com.google.common.util.concurrent.UncheckedExecutionException: > java.lang.RuntimeException: Fail to check or create znode for chRoot > F:\kylin\kylin_metadata_idea due to > at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2263) > at com.google.common.cache.LocalCache.get(LocalCache.java:4000) > at > com.google.common.cache.LocalCache$LocalManualCache.get(LocalCache.java:4789) > at org.apache.kylin.common.util.ZKUtil.getZookeeperClient(ZKUtil.java:123) > ... 68 more -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Resolved] (KYLIN-3935) ZKUtil acquire the wrong Zookeeper Path on windows
[ https://issues.apache.org/jira/browse/KYLIN-3935?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] nichunen resolved KYLIN-3935. - Resolution: Fixed > ZKUtil acquire the wrong Zookeeper Path on windows > -- > > Key: KYLIN-3935 > URL: https://issues.apache.org/jira/browse/KYLIN-3935 > Project: Kylin > Issue Type: Bug >Affects Versions: v2.6.1 >Reporter: Na Zhai >Assignee: Na Zhai >Priority: Major > Fix For: v3.0.0 > > > In my windows env, when I run Kylin, Kylin service can't start. In class > ZKUtil, I found Kylin use File(path).getCanonicalPath() to norm windows path, > however this will get a path like ' C:\kylin\kylin_metadata'.For Zookeeper, > the path must start with / character. > {color:#FF}return new File(path).toURI().getPath(){color}Â might be > better!!! > Below is stackTrace: > : java.lang.RuntimeException: > com.google.common.util.concurrent.UncheckedExecutionException: > java.lang.RuntimeException: Fail to check or create znode for chRoot > F:\kylin\kylin_metadata_idea due to > at org.apache.kylin.common.util.ZKUtil.getZookeeperClient(ZKUtil.java:137) > at org.apache.kylin.common.util.ZKUtil.getZookeeperClient(ZKUtil.java:115) > at > org.apache.kylin.job.lock.zookeeper.ZookeeperDistributedLock$Factory.(ZookeeperDistributedLock.java:57) > at > org.apache.kylin.job.lock.zookeeper.ZookeeperDistributedLock$Factory.(ZookeeperDistributedLock.java:53) > at > org.apache.kylin.job.lock.zookeeper.ZookeeperJobLock.(ZookeeperJobLock.java:32) > at > org.apache.kylin.rest.service.JobService.afterPropertiesSet(JobService.java:132) > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1687) > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1624) > ... 61 more > Caused by: com.google.common.util.concurrent.UncheckedExecutionException: > java.lang.RuntimeException: Fail to check or create znode for chRoot > F:\kylin\kylin_metadata_idea due to > at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2263) > at com.google.common.cache.LocalCache.get(LocalCache.java:4000) > at > com.google.common.cache.LocalCache$LocalManualCache.get(LocalCache.java:4789) > at org.apache.kylin.common.util.ZKUtil.getZookeeperClient(ZKUtil.java:123) > ... 68 more -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Reopened] (KYLIN-3841) Build Global Dict by MR/Hive
[ https://issues.apache.org/jira/browse/KYLIN-3841?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] nichunen reopened KYLIN-3841: - Reopen to set release version > Build Global Dict by MR/Hive > > > Key: KYLIN-3841 > URL: https://issues.apache.org/jira/browse/KYLIN-3841 > Project: Kylin > Issue Type: Improvement >Reporter: jinguowei >Assignee: jinguowei >Priority: Major > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (KYLIN-3841) Build Global Dict by MR/Hive
[ https://issues.apache.org/jira/browse/KYLIN-3841?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] nichunen updated KYLIN-3841: Affects Version/s: v2.6.1 Fix Version/s: v3.0.0 Component/s: Job Engine > Build Global Dict by MR/Hive > > > Key: KYLIN-3841 > URL: https://issues.apache.org/jira/browse/KYLIN-3841 > Project: Kylin > Issue Type: Improvement > Components: Job Engine >Affects Versions: v2.6.1 >Reporter: jinguowei >Assignee: jinguowei >Priority: Major > Fix For: v3.0.0 > > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Resolved] (KYLIN-3841) Build Global Dict by MR/Hive
[ https://issues.apache.org/jira/browse/KYLIN-3841?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] nichunen resolved KYLIN-3841. - Resolution: Fixed > Build Global Dict by MR/Hive > > > Key: KYLIN-3841 > URL: https://issues.apache.org/jira/browse/KYLIN-3841 > Project: Kylin > Issue Type: Improvement > Components: Job Engine >Affects Versions: v2.6.1 >Reporter: jinguowei >Assignee: jinguowei >Priority: Major > Fix For: v3.0.0 > > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (KYLIN-3608) Move dependency versions to top level pom properties
[ https://issues.apache.org/jira/browse/KYLIN-3608?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] nichunen updated KYLIN-3608: Affects Version/s: v2.6.1 Fix Version/s: v3.0.0 Component/s: Others > Move dependency versions to top level pom properties > > > Key: KYLIN-3608 > URL: https://issues.apache.org/jira/browse/KYLIN-3608 > Project: Kylin > Issue Type: Task > Components: Others >Affects Versions: v2.6.1 >Reporter: Ted Yu >Assignee: zhoujie >Priority: Minor > Fix For: v3.0.0 > > > There are some non-top level pom.xml files where dependency version is > referenced directly. > core-common/pom.xml is an example. > We should move all dependency versions to top level pom properties -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Resolved] (KYLIN-3608) Move dependency versions to top level pom properties
[ https://issues.apache.org/jira/browse/KYLIN-3608?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] nichunen resolved KYLIN-3608. - Resolution: Fixed > Move dependency versions to top level pom properties > > > Key: KYLIN-3608 > URL: https://issues.apache.org/jira/browse/KYLIN-3608 > Project: Kylin > Issue Type: Task > Components: Others >Affects Versions: v2.6.1 >Reporter: Ted Yu >Assignee: zhoujie >Priority: Minor > Fix For: v3.0.0 > > > There are some non-top level pom.xml files where dependency version is > referenced directly. > core-common/pom.xml is an example. > We should move all dependency versions to top level pom properties -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Created] (KYLIN-3970) NRT Streaming cannot work at HDP3.0
XiaoXiang Yu created KYLIN-3970: --- Summary: NRT Streaming cannot work at HDP3.0 Key: KYLIN-3970 URL: https://issues.apache.org/jira/browse/KYLIN-3970 Project: Kylin Issue Type: Bug Components: NRT Streaming Affects Versions: v2.6.1 Reporter: XiaoXiang Yu Assignee: XiaoXiang Yu Fix For: v3.0.0, v2.6.2 We found that when using [apache-kylin-2.6.1-bin-hadoop3.tar.gz|https://www.apache.org/dyn/closer.cgi/kylin/apache-kylin-2.6.1/apache-kylin-2.6.1-bin-hadoop3.tar.gz], NRT streaming cannot work in serval step for jar conflict problem. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (KYLIN-3970) NRT Streaming cannot work at HDP3.0
[ https://issues.apache.org/jira/browse/KYLIN-3970?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] XiaoXiang Yu updated KYLIN-3970: Labels: HDP Hadoop3 (was: ) > NRT Streaming cannot work at HDP3.0 > --- > > Key: KYLIN-3970 > URL: https://issues.apache.org/jira/browse/KYLIN-3970 > Project: Kylin > Issue Type: Bug > Components: NRT Streaming >Affects Versions: v2.6.1 >Reporter: XiaoXiang Yu >Assignee: XiaoXiang Yu >Priority: Major > Labels: HDP, Hadoop3 > Fix For: v3.0.0, v2.6.2 > > > We found that when using > [apache-kylin-2.6.1-bin-hadoop3.tar.gz|https://www.apache.org/dyn/closer.cgi/kylin/apache-kylin-2.6.1/apache-kylin-2.6.1-bin-hadoop3.tar.gz], > NRT streaming cannot work in serval step for jar conflict problem. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (KYLIN-3970) NRT Streaming cannot work at HDP3.0
[ https://issues.apache.org/jira/browse/KYLIN-3970?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] XiaoXiang Yu updated KYLIN-3970: Attachment: image-2019-04-23-14-25-51-066.png > NRT Streaming cannot work at HDP3.0 > --- > > Key: KYLIN-3970 > URL: https://issues.apache.org/jira/browse/KYLIN-3970 > Project: Kylin > Issue Type: Bug > Components: NRT Streaming >Affects Versions: v2.6.1 >Reporter: XiaoXiang Yu >Assignee: XiaoXiang Yu >Priority: Major > Labels: HDP, Hadoop3 > Fix For: v3.0.0, v2.6.2 > > Attachments: image-2019-04-23-14-25-51-066.png > > > We found that when using > [apache-kylin-2.6.1-bin-hadoop3.tar.gz|https://www.apache.org/dyn/closer.cgi/kylin/apache-kylin-2.6.1/apache-kylin-2.6.1-bin-hadoop3.tar.gz], > NRT streaming cannot work in serval step for jar conflict problem. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (KYLIN-3970) NRT Streaming cannot work at HDP3.0
[ https://issues.apache.org/jira/browse/KYLIN-3970?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] XiaoXiang Yu updated KYLIN-3970: Description: We found that when using [apache-kylin-2.6.1-bin-hadoop3.tar.gz|https://www.apache.org/dyn/closer.cgi/kylin/apache-kylin-2.6.1/apache-kylin-2.6.1-bin-hadoop3.tar.gz], NRT streaming cannot work in serval step for jar conflict problem.  !image-2019-04-23-14-25-51-066.png! was:We found that when using [apache-kylin-2.6.1-bin-hadoop3.tar.gz|https://www.apache.org/dyn/closer.cgi/kylin/apache-kylin-2.6.1/apache-kylin-2.6.1-bin-hadoop3.tar.gz], NRT streaming cannot work in serval step for jar conflict problem. > NRT Streaming cannot work at HDP3.0 > --- > > Key: KYLIN-3970 > URL: https://issues.apache.org/jira/browse/KYLIN-3970 > Project: Kylin > Issue Type: Bug > Components: NRT Streaming >Affects Versions: v2.6.1 >Reporter: XiaoXiang Yu >Assignee: XiaoXiang Yu >Priority: Major > Labels: HDP, Hadoop3 > Fix For: v3.0.0, v2.6.2 > > Attachments: image-2019-04-23-14-25-51-066.png > > > We found that when using > [apache-kylin-2.6.1-bin-hadoop3.tar.gz|https://www.apache.org/dyn/closer.cgi/kylin/apache-kylin-2.6.1/apache-kylin-2.6.1-bin-hadoop3.tar.gz], > NRT streaming cannot work in serval step for jar conflict problem. >  > !image-2019-04-23-14-25-51-066.png! -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (KYLIN-3970) NRT Streaming cannot work at HDP3.0
[ https://issues.apache.org/jira/browse/KYLIN-3970?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16823735#comment-16823735 ] XiaoXiang Yu commented on KYLIN-3970: -  h3. *First problem:* *Kafka jar conflict* org.apache.kylin.engine.mr.exception.MapReduceException: no counters for job job_1555653800318_0004Job Diagnostics:Task failed task_1555653800318_0004_m_00 Job failed as tasks failed. failedMaps:1 failedReduces:0 killedMaps:0 killedReduces: 0 Failure task Diagnostics: Error: org.apache.kafka.clients.consumer.ConsumerConfig.configNames()Ljava/util/Set; at org.apache.kylin.engine.mr.common.MapReduceExecutable.doWork(MapReduceExecutable.java:173) at org.apache.kylin.job.execution.AbstractExecutable.execute(AbstractExecutable.java:166) at org.apache.kylin.job.execution.DefaultChainedExecutable.doWork(DefaultChainedExecutable.java:71) at org.apache.kylin.job.execution.AbstractExecutable.execute(AbstractExecutable.java:166) at org.apache.kylin.job.impl.threadpool.DefaultScheduler$JobRunner.run(DefaultScheduler.java:114) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) h3. *Second problem: Hive null value* org.apache.kylin.engine.mr.exception.MapReduceException: no counters for job job_1555653800318_0007Job Diagnostics:Task failed task_1555653800318_0007_m_00 Job failed as tasks failed. failedMaps:1 failedReduces:0 killedMaps:0 killedReduces: 0 Failure task Diagnostics: Error: java.lang.IllegalArgumentException: there is no valid date pattern for:\N at org.apache.kylin.common.util.DateFormat.stringToMillis(DateFormat.java:124) at org.apache.kylin.metadata.datatype.DataTypeOrder$DateTimeOrder.toComparable(DataTypeOrder.java:154) at org.apache.kylin.metadata.datatype.DataTypeOrder$DateTimeOrder.toComparable(DataTypeOrder.java:148) at org.apache.kylin.metadata.datatype.DataTypeOrder.compare(DataTypeOrder.java:95) at org.apache.kylin.metadata.datatype.DataTypeOrder.max(DataTypeOrder.java:90) at org.apache.kylin.engine.mr.steps.FactDistinctColumnsMapper.doMap(FactDistinctColumnsMapper.java:194) at org.apache.kylin.engine.mr.KylinMapper.map(KylinMapper.java:77) at org.apache.hadoop.mapreduce.Mapper.run(Mapper.java:146) at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:799) at org.apache.hadoop.mapred.MapTask.run(MapTask.java:347) at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:174) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAs(Subject.java:422) at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1730) at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:168) at org.apache.kylin.engine.mr.common.MapReduceExecutable.doWork(MapReduceExecutable.java:173) at org.apache.kylin.job.execution.AbstractExecutable.execute(AbstractExecutable.java:166) at org.apache.kylin.job.execution.DefaultChainedExecutable.doWork(DefaultChainedExecutable.java:71) at org.apache.kylin.job.execution.AbstractExecutable.execute(AbstractExecutable.java:166) at org.apache.kylin.job.impl.threadpool.DefaultScheduler$JobRunner.run(DefaultScheduler.java:114) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748)  > NRT Streaming cannot work at HDP3.0 > --- > > Key: KYLIN-3970 > URL: https://issues.apache.org/jira/browse/KYLIN-3970 > Project: Kylin > Issue Type: Bug > Components: NRT Streaming >Affects Versions: v2.6.1 >Reporter: XiaoXiang Yu >Assignee: XiaoXiang Yu >Priority: Major > Labels: HDP, Hadoop3 > Fix For: v3.0.0, v2.6.2 > > Attachments: image-2019-04-23-14-25-51-066.png > > > We found that when using > [apache-kylin-2.6.1-bin-hadoop3.tar.gz|https://www.apache.org/dyn/closer.cgi/kylin/apache-kylin-2.6.1/apache-kylin-2.6.1-bin-hadoop3.tar.gz], > NRT streaming cannot work in serval step for jar conflict problem. >  > !image-2019-04-23-14-25-51-066.png! -- This message was sent by Atlassian JIRA (v7.6.3#76005)