[jira] [Commented] (KYLIN-4022) when Adhoc Push Down then Unrecognized column type: DECIMAL(xx,xx)
[
https://issues.apache.org/jira/browse/KYLIN-4022?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16851500#comment-16851500
]
youcheng.zhang commented on KYLIN-4022:
---
Hello [~javalife0...@126.com], Thanks for your contribution.
But I doubt that why
{code:java}
columnTypeName = resultSetMetaData.getColumnTypeName(columnIndex);
{code}
columnTypeName get result with DECIMAL(38,6)?
Can you explain more information which data source you are connecting?
> when Adhoc Push Down then Unrecognized column type: DECIMAL(xx,xx)
> --
>
> Key: KYLIN-4022
> URL: https://issues.apache.org/jira/browse/KYLIN-4022
> Project: Kylin
> Issue Type: Improvement
>Reporter: jinguowei
>Assignee: jinguowei
>Priority: Major
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
[GitHub] [kylin] coveralls commented on issue #666: KYLIN-4020 fix_length rowkey encode without sepecified length can be …
coveralls commented on issue #666: KYLIN-4020 fix_length rowkey encode without sepecified length can be … URL: https://github.com/apache/kylin/pull/666#issuecomment-497054848 ## Pull Request Test Coverage Report for [Build 4555](https://coveralls.io/builds/23678245) * **0** of **0** changed or added relevant lines in **0** files are covered. * **8** unchanged lines in **4** files lost coverage. * Overall coverage decreased (**-0.004%**) to **28.295%** --- | Files with Coverage Reduction | New Missed Lines | % | | :-|--|--: | | [stream-core/src/main/java/org/apache/kylin/stream/core/storage/columnar/ColumnarStoreCache.java](https://coveralls.io/builds/23678245/source?filename=stream-core%2Fsrc%2Fmain%2Fjava%2Forg%2Fapache%2Fkylin%2Fstream%2Fcore%2Fstorage%2Fcolumnar%2FColumnarStoreCache.java#L136) | 1 | 55.81% | | [server-base/src/main/java/org/apache/kylin/rest/util/QueryRequestLimits.java](https://coveralls.io/builds/23678245/source?filename=server-base%2Fsrc%2Fmain%2Fjava%2Forg%2Fapache%2Fkylin%2Frest%2Futil%2FQueryRequestLimits.java#L72) | 1 | 47.62% | | [core-cube/src/main/java/org/apache/kylin/cube/cuboid/TreeCuboidScheduler.java](https://coveralls.io/builds/23678245/source?filename=core-cube%2Fsrc%2Fmain%2Fjava%2Forg%2Fapache%2Fkylin%2Fcube%2Fcuboid%2FTreeCuboidScheduler.java#L124) | 2 | 68.46% | | [core-cube/src/main/java/org/apache/kylin/cube/inmemcubing/MemDiskStore.java](https://coveralls.io/builds/23678245/source?filename=core-cube%2Fsrc%2Fmain%2Fjava%2Forg%2Fapache%2Fkylin%2Fcube%2Finmemcubing%2FMemDiskStore.java#L449) | 4 | 78.12% | | Totals | [](https://coveralls.io/builds/23678245) | | :-- | --: | | Change from base [Build 4541](https://coveralls.io/builds/2358): | -0.004% | | Covered Lines: | 23246 | | Relevant Lines: | 82155 | --- # - [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 #666: KYLIN-4020 fix_length rowkey encode without sepecified length can be …
codecov-io commented on issue #666: KYLIN-4020 fix_length rowkey encode without sepecified length can be … URL: https://github.com/apache/kylin/pull/666#issuecomment-497053582 # [Codecov](https://codecov.io/gh/apache/kylin/pull/666?src=pr=h1) Report > Merging [#666](https://codecov.io/gh/apache/kylin/pull/666?src=pr=desc) into [master](https://codecov.io/gh/apache/kylin/commit/47431ba0da7c3cce533f4d9dcd600654f33e0c90?src=pr=desc) will **decrease** coverage by `0.01%`. > The diff coverage is `n/a`. [](https://codecov.io/gh/apache/kylin/pull/666?src=pr=tree) ```diff @@ Coverage Diff @@ ## master #666 +/- ## - Coverage 25.81% 25.79% -0.02% + Complexity 6011 6007 -4 Files 1382 1382 Lines 8215582155 Branches 1151111511 - Hits 2120921194 -15 - Misses5890358912 +9 - Partials 2043 2049 +6 ``` | [Impacted Files](https://codecov.io/gh/apache/kylin/pull/666?src=pr=tree) | Coverage Δ | Complexity Δ | | |---|---|---|---| | [...he/kylin/dict/lookup/cache/RocksDBLookupTable.java](https://codecov.io/gh/apache/kylin/pull/666/diff?src=pr=tree#diff-Y29yZS1kaWN0aW9uYXJ5L3NyYy9tYWluL2phdmEvb3JnL2FwYWNoZS9reWxpbi9kaWN0L2xvb2t1cC9jYWNoZS9Sb2Nrc0RCTG9va3VwVGFibGUuamF2YQ==) | `72.97% <0%> (-5.41%)` | `6% <0%> (-1%)` | | | [...org/apache/kylin/rest/util/QueryRequestLimits.java](https://codecov.io/gh/apache/kylin/pull/666/diff?src=pr=tree#diff-c2VydmVyLWJhc2Uvc3JjL21haW4vamF2YS9vcmcvYXBhY2hlL2t5bGluL3Jlc3QvdXRpbC9RdWVyeVJlcXVlc3RMaW1pdHMuamF2YQ==) | `35.71% <0%> (-4.77%)` | `5% <0%> (-1%)` | | | [...ream/core/storage/columnar/ColumnarStoreCache.java](https://codecov.io/gh/apache/kylin/pull/666/diff?src=pr=tree#diff-c3RyZWFtLWNvcmUvc3JjL21haW4vamF2YS9vcmcvYXBhY2hlL2t5bGluL3N0cmVhbS9jb3JlL3N0b3JhZ2UvY29sdW1uYXIvQ29sdW1uYXJTdG9yZUNhY2hlLmphdmE=) | `48.83% <0%> (-2.33%)` | `7% <0%> (-1%)` | | | [.../apache/kylin/cube/cuboid/TreeCuboidScheduler.java](https://codecov.io/gh/apache/kylin/pull/666/diff?src=pr=tree#diff-Y29yZS1jdWJlL3NyYy9tYWluL2phdmEvb3JnL2FwYWNoZS9reWxpbi9jdWJlL2N1Ym9pZC9UcmVlQ3Vib2lkU2NoZWR1bGVyLmphdmE=) | `63.84% <0%> (-2.31%)` | `0% <0%> (ø)` | | | [...rg/apache/kylin/cube/inmemcubing/MemDiskStore.java](https://codecov.io/gh/apache/kylin/pull/666/diff?src=pr=tree#diff-Y29yZS1jdWJlL3NyYy9tYWluL2phdmEvb3JnL2FwYWNoZS9reWxpbi9jdWJlL2lubWVtY3ViaW5nL01lbURpc2tTdG9yZS5qYXZh) | `69.6% <0%> (-1.52%)` | `7% <0%> (ø)` | | | [...a/org/apache/kylin/dict/Number2BytesConverter.java](https://codecov.io/gh/apache/kylin/pull/666/diff?src=pr=tree#diff-Y29yZS1kaWN0aW9uYXJ5L3NyYy9tYWluL2phdmEvb3JnL2FwYWNoZS9reWxpbi9kaWN0L051bWJlcjJCeXRlc0NvbnZlcnRlci5qYXZh) | `81.74% <0%> (-0.8%)` | `17% <0%> (-1%)` | | -- [Continue to review full report at Codecov](https://codecov.io/gh/apache/kylin/pull/666?src=pr=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/666?src=pr=footer). Last update [47431ba...4939d77](https://codecov.io/gh/apache/kylin/pull/666?src=pr=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
[jira] [Commented] (KYLIN-4020) fix_length rowkey encode without sepecified length can be saved but cause CreateHTable step failed
[ https://issues.apache.org/jira/browse/KYLIN-4020?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16851102#comment-16851102 ] ASF GitHub Bot commented on KYLIN-4020: --- Qsimple commented on pull request #666: KYLIN-4020 fix_length rowkey encode without sepecified length can be … URL: https://github.com/apache/kylin/pull/666 …saved but cause CreateHTable step failed 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 > fix_length rowkey encode without sepecified length can be saved but cause > CreateHTable step failed > -- > > Key: KYLIN-4020 > URL: https://issues.apache.org/jira/browse/KYLIN-4020 > Project: Kylin > Issue Type: Improvement > Components: Metadata >Affects Versions: v2.5.2 >Reporter: Yuzhang QIU >Priority: Major > > Hi dear team: > Just as title said. > Maybe there should have more strict check for advanced settings, I think. > How do you think about this? > If there already have same JIRA，please inform me and close this one. > > Best regards > > yuzhang -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[GitHub] [kylin] Qsimple opened a new pull request #666: KYLIN-4020 fix_length rowkey encode without sepecified length can be …
Qsimple opened a new pull request #666: KYLIN-4020 fix_length rowkey encode without sepecified length can be … URL: https://github.com/apache/kylin/pull/666 …saved but cause CreateHTable step failed 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 #665: KYLIN-4022 when Adhoc Push Down then Unrecognized column type: DECIMA…
coveralls commented on issue #665: KYLIN-4022 when Adhoc Push Down then Unrecognized column type: DECIMA… URL: https://github.com/apache/kylin/pull/665#issuecomment-496868345 ## Pull Request Test Coverage Report for [Build 4554](https://coveralls.io/builds/23667461) * **0** of **1** **(0.0%)** changed or added relevant line in **1** file are covered. * **6** unchanged lines in **3** files lost coverage. * Overall coverage decreased (**-0.001%**) to **28.298%** --- | Changes Missing Coverage | Covered Lines | Changed/Added Lines | % | | :-|--||---: | | [query/src/main/java/org/apache/kylin/query/adhoc/PushDownRunnerJdbcImpl.java](https://coveralls.io/builds/23667461/source?filename=query%2Fsrc%2Fmain%2Fjava%2Forg%2Fapache%2Fkylin%2Fquery%2Fadhoc%2FPushDownRunnerJdbcImpl.java#L250) | 0 | 1 | 0.0% | Files with Coverage Reduction | New Missed Lines | % | | :-|--|--: | | [server-base/src/main/java/org/apache/kylin/rest/util/QueryRequestLimits.java](https://coveralls.io/builds/23667461/source?filename=server-base%2Fsrc%2Fmain%2Fjava%2Forg%2Fapache%2Fkylin%2Frest%2Futil%2FQueryRequestLimits.java#L72) | 1 | 47.62% | | [core-job/src/main/java/org/apache/kylin/job/impl/threadpool/DefaultScheduler.java](https://coveralls.io/builds/23667461/source?filename=core-job%2Fsrc%2Fmain%2Fjava%2Forg%2Fapache%2Fkylin%2Fjob%2Fimpl%2Fthreadpool%2FDefaultScheduler.java#L194) | 2 | 80.23% | | [core-cube/src/main/java/org/apache/kylin/cube/inmemcubing/MemDiskStore.java](https://coveralls.io/builds/23667461/source?filename=core-cube%2Fsrc%2Fmain%2Fjava%2Forg%2Fapache%2Fkylin%2Fcube%2Finmemcubing%2FMemDiskStore.java#L449) | 3 | 78.42% | | Totals | [](https://coveralls.io/builds/23667461) | | :-- | --: | | Change from base [Build 4541](https://coveralls.io/builds/2358): | -0.001% | | Covered Lines: | 23248 | | Relevant Lines: | 82155 | --- # - [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
[jira] [Commented] (KYLIN-4018) apache kylin 连接powerbi出错
[ https://issues.apache.org/jira/browse/KYLIN-4018?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16850702#comment-16850702 ] Billy Liu commented on KYLIN-4018: -- How about this one: https://www.jianshu.com/p/eb59a8f174d1 > apache kylin 连接powerbi出错 > > > Key: KYLIN-4018 > URL: https://issues.apache.org/jira/browse/KYLIN-4018 > Project: Kylin > Issue Type: Wish > Components: Driver - ODBC > Environment: apache kylin，powerbi desktop >Reporter: jamie_lee >Priority: Major > > 我在将apache kylin的数据源连接到powebi > desktop时使用了KylinODBCDriver的驱动，好像只支持导入模式，不支持directquery模式，以至于虽然连接成功了，但是导入的数据好像格式有些问题(有些类型为bigint的字段显示为0)，所以现在apache > kylin和powerbi之间的odbc驱动不支持directquery模式了么？或者是不是我现在用的驱动不对？我应该用哪个驱动呢？求解答，谢谢！ -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (KYLIN-4018) apache kylin 连接powerbi出错
[ https://issues.apache.org/jira/browse/KYLIN-4018?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16850657#comment-16850657 ] jamie_lee commented on KYLIN-4018: -- i will be thankful if you can provide a 3dparty connector which provides directquery for kylin and powerbi,cause i have searched a lot and got nothing,thanks! > apache kylin 连接powerbi出错 > > > Key: KYLIN-4018 > URL: https://issues.apache.org/jira/browse/KYLIN-4018 > Project: Kylin > Issue Type: Wish > Components: Driver - ODBC > Environment: apache kylin，powerbi desktop >Reporter: jamie_lee >Priority: Major > > 我在将apache kylin的数据源连接到powebi > desktop时使用了KylinODBCDriver的驱动，好像只支持导入模式，不支持directquery模式，以至于虽然连接成功了，但是导入的数据好像格式有些问题(有些类型为bigint的字段显示为0)，所以现在apache > kylin和powerbi之间的odbc驱动不支持directquery模式了么？或者是不是我现在用的驱动不对？我应该用哪个驱动呢？求解答，谢谢！ -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (KYLIN-4022) when Adhoc Push Down then Unrecognized column type: DECIMAL(xx,xx)
[ https://issues.apache.org/jira/browse/KYLIN-4022?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16850651#comment-16850651 ] ASF GitHub Bot commented on KYLIN-4022: --- javalife0312 commented on pull request #665: KYLIN-4022 when Adhoc Push Down then Unrecognized column type: DECIMA… URL: https://github.com/apache/kylin/pull/665 when query like select dnum from table and dnum is DECIMAL(38,6) then throw ERROR [Query 0e816abd-28cc-4f6e-9116-f1349c1f1b39-72] service.QueryService:1001 : pushdown engine failed current query too java.sql.SQLException: Unrecognized column type: DECIMAL(38,6) at org.apache.kylin.query.adhoc.PushDownRunnerJdbcImpl.toSqlType(PushDownRunnerJdbcImpl.java:263) at org.apache.kylin.query.adhoc.PushDownRunnerJdbcImpl.extractColumnMeta(PushDownRunnerJdbcImpl.java:195) at org.apache.kylin.query.adhoc.PushDownRunnerJdbcImpl.executeQuery(PushDownRunnerJdbcImpl.java:71) at org.apache.kylin.query.util.PushDownUtil.tryPushDownQuery(PushDownUtil.java:122) at org.apache.kylin.query.util.PushDownUtil.tryPushDownSelectQuery(PushDownUtil.java:69) at org.apache.kylin.rest.service.QueryService.pushDownQuery(QueryService.java:998) at org.apache.kylin.rest.service.QueryService.executeRequest(QueryService.java:954) at org.apache.kylin.rest.service.QueryService.queryWithSqlMassage(QueryService.java:652) at org.apache.kylin.rest.service.QueryService.query(QueryService.java:212) at org.apache.kylin.rest.service.QueryService.queryAndUpdateCache(QueryService.java:479) at org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:440) at org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:373) at org.apache.kylin.rest.controller.QueryController.query(QueryController.java:87) 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 Adhoc Push Down then Unrecognized column type: DECIMAL(xx,xx) > -- > > Key: KYLIN-4022 > URL: https://issues.apache.org/jira/browse/KYLIN-4022 > Project: Kylin > Issue Type: Improvement >Reporter: jinguowei >Assignee: jinguowei >Priority: Major > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[GitHub] [kylin] javalife0312 opened a new pull request #665: KYLIN-4022 when Adhoc Push Down then Unrecognized column type: DECIMA…
javalife0312 opened a new pull request #665: KYLIN-4022 when Adhoc Push Down then Unrecognized column type: DECIMA… URL: https://github.com/apache/kylin/pull/665 when query like select dnum from table and dnum is DECIMAL(38,6) then throw ERROR [Query 0e816abd-28cc-4f6e-9116-f1349c1f1b39-72] service.QueryService:1001 : pushdown engine failed current query too java.sql.SQLException: Unrecognized column type: DECIMAL(38,6) at org.apache.kylin.query.adhoc.PushDownRunnerJdbcImpl.toSqlType(PushDownRunnerJdbcImpl.java:263) at org.apache.kylin.query.adhoc.PushDownRunnerJdbcImpl.extractColumnMeta(PushDownRunnerJdbcImpl.java:195) at org.apache.kylin.query.adhoc.PushDownRunnerJdbcImpl.executeQuery(PushDownRunnerJdbcImpl.java:71) at org.apache.kylin.query.util.PushDownUtil.tryPushDownQuery(PushDownUtil.java:122) at org.apache.kylin.query.util.PushDownUtil.tryPushDownSelectQuery(PushDownUtil.java:69) at org.apache.kylin.rest.service.QueryService.pushDownQuery(QueryService.java:998) at org.apache.kylin.rest.service.QueryService.executeRequest(QueryService.java:954) at org.apache.kylin.rest.service.QueryService.queryWithSqlMassage(QueryService.java:652) at org.apache.kylin.rest.service.QueryService.query(QueryService.java:212) at org.apache.kylin.rest.service.QueryService.queryAndUpdateCache(QueryService.java:479) at org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:440) at org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:373) at org.apache.kylin.rest.controller.QueryController.query(QueryController.java:87) 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 #665: KYLIN-4022 when Adhoc Push Down then Unrecognized column type: DECIMA…
asfgit commented on issue #665: KYLIN-4022 when Adhoc Push Down then Unrecognized column type: DECIMA… URL: https://github.com/apache/kylin/pull/665#issuecomment-496853518 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-4022) when Adhoc Push Down then Unrecognized column type: DECIMAL(xx,xx)
[ https://issues.apache.org/jira/browse/KYLIN-4022?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16850636#comment-16850636 ] jinguowei commented on KYLIN-4022: -- when query like select dnum from table and dnum is DECIMAL(38,6) then throw 019-05-29 16:13:06,544 ERROR [Query 0e816abd-28cc-4f6e-9116-f1349c1f1b39-72] service.QueryService:1001 : pushdown engine failed current query too java.sql.SQLException: Unrecognized column type: DECIMAL(38,6) at org.apache.kylin.query.adhoc.PushDownRunnerJdbcImpl.toSqlType(PushDownRunnerJdbcImpl.java:263) at org.apache.kylin.query.adhoc.PushDownRunnerJdbcImpl.extractColumnMeta(PushDownRunnerJdbcImpl.java:195) at org.apache.kylin.query.adhoc.PushDownRunnerJdbcImpl.executeQuery(PushDownRunnerJdbcImpl.java:71) at org.apache.kylin.query.util.PushDownUtil.tryPushDownQuery(PushDownUtil.java:122) at org.apache.kylin.query.util.PushDownUtil.tryPushDownSelectQuery(PushDownUtil.java:69) at org.apache.kylin.rest.service.QueryService.pushDownQuery(QueryService.java:998) at org.apache.kylin.rest.service.QueryService.executeRequest(QueryService.java:954) at org.apache.kylin.rest.service.QueryService.queryWithSqlMassage(QueryService.java:652) at org.apache.kylin.rest.service.QueryService.query(QueryService.java:212) at org.apache.kylin.rest.service.QueryService.queryAndUpdateCache(QueryService.java:479) at org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:440) at org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:373) at org.apache.kylin.rest.controller.QueryController.query(QueryController.java:87) > when Adhoc Push Down then Unrecognized column type: DECIMAL(xx,xx) > -- > > Key: KYLIN-4022 > URL: https://issues.apache.org/jira/browse/KYLIN-4022 > Project: Kylin > Issue Type: Improvement >Reporter: jinguowei >Assignee: jinguowei >Priority: Major > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Created] (KYLIN-4022) when Adhoc Push Down then Unrecognized column type: DECIMAL(xx,xx)
jinguowei created KYLIN-4022: Summary: when Adhoc Push Down then Unrecognized column type: DECIMAL(xx,xx) Key: KYLIN-4022 URL: https://issues.apache.org/jira/browse/KYLIN-4022 Project: Kylin Issue Type: Improvement Reporter: jinguowei Assignee: jinguowei -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Closed] (KYLIN-3958) MrHive-Dict support build by livy
[ https://issues.apache.org/jira/browse/KYLIN-3958?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jinguowei closed KYLIN-3958. Resolution: Fixed > MrHive-Dict support build by livy > - > > Key: KYLIN-3958 > URL: https://issues.apache.org/jira/browse/KYLIN-3958 > Project: Kylin > Issue Type: Improvement >Reporter: jinguowei >Assignee: jinguowei >Priority: Major > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (KYLIN-3996) postgresql can not to be used to construct the flat hive table in NO.1 step in building cube via datasourcedefaultSdk
[
https://issues.apache.org/jira/browse/KYLIN-3996?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16850537#comment-16850537
]
youcheng.zhang commented on KYLIN-3996:
---
[~duhj2] Thanks for your comment.
{code:java}
kylin.source.default=8{code}
is old version of rdbms data source.
{code:java}
kylin.source.default=16{code}
is new version and easier to implement a new rdbms data source.
> postgresql can not to be used to construct the flat hive table in NO.1 step
> in building cube via datasourcedefaultSdk
> -
>
> Key: KYLIN-3996
> URL: https://issues.apache.org/jira/browse/KYLIN-3996
> Project: Kylin
> Issue Type: Bug
> Components: Driver - JDBC
>Affects Versions: v2.6.1
> Environment: kylin3.0.0+hadoop2.7.4+hive2.1.1+hbase1.2.6
>Reporter: haijiandu
>Assignee: XiaoXiang Yu
>Priority: Critical
> Labels: datasource, postgresql, sdk
> Attachments: kylin_log_error_1.jpg, kylin_log_error_2.jpg,
> kylin_log_error_3.jpg, kylin_log_error_4.jpg, kylin_log_error_5.jpg,
> kylin_properties_duhj.jpg, kylin_sql.jpg,
> kylin_sqoopToflatHiveTable_Error.jpg, postgresql_xml.jpg,
> server_config_kylin_1.jpg, server_config_kylin_1.jpg,
> server_config_kylin_2.jpg
>
>
> postgresql can not to be used to construct the flat hive table in NO.1 step
> in building cube via datasourcedefaultSdk. whether in kylin.properties or in
> postgresql.xml，corresponding configureations have been finished as required
> by official specification.There alwarys occurs a problem such as "ERROR
> manager.SqlManager: Error executing statement:
> org.postgresql.util.PSQLException:
> ERROR: syntax error at or near ".",
> when kylin is linked to postgresql databese, it seems that the errors happen
> in sql brought by kylin. the sql has back quote,as it is "`" ,that causes
> query failure brought by table name and columns defined by back quote(`).
> as required, in kylin.properties ,its configuration has been as followings
> kylin.source.default=16
> kylin.source.jdbc.connection-url=jdbc:postgresql://192.168.75.123:5432/dvdrental
> kylin.source.jdbc.driver=org.postgresql.Driver
> kylin.source.jdbc.dialect=postgresql
> kylin.source.jdbc.adaptor=org.apache.kylin.sdk.datasource.adaptor.DefaultAdaptor
> kylin.source.jdbc.user=postgres
> kylin.source.jdbc.pass=1234
> kylin.source.jdbc.sqoop-home=/duhj/sqoop-1.4.7.bin__hadoop-2.6.0
> kylin.source.jdbc.filed-delimiter=|
> kylin.source.jdbc.sqoop-mapper-num=4
> what is more, in
> ~/apache-kylin-3.0/conf/datasource/postgresql.xml，corresponding conf is as
> followings:
> -
>
>
>
>
>
>
>
>
>
>
> is there a method to solve it?
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
