[
https://issues.apache.org/jira/browse/KYLIN-3500?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16585478#comment-16585478
]
ASF GitHub Bot commented on KYLIN-3500:
---------------------------------------
asfgit commented on issue #203: KYLIN-3500 fix dumplicated tablename at
createSqoopToFlatHiveStep wh…
URL: https://github.com/apache/kylin/pull/203#issuecomment-414211458
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
> kylin 2.4 use jdbc datasource :Unknown column 'A.A.CRT_DATE' in 'where clause'
> ------------------------------------------------------------------------------
>
> Key: KYLIN-3500
> URL: https://issues.apache.org/jira/browse/KYLIN-3500
> Project: Kylin
> Issue Type: Bug
> Components: RDBMS Source
> Affects Versions: v2.3.0, v2.4.0
> Environment: Hadoop2.7.6+Hive-1.2.2+HBase1.2.6+Sqoop1.4.7
> Reporter: cqli
> Assignee: Shaoxiong Zhan
> Priority: Major
> Fix For: v2.4.1, v2.5.0
>
> Attachments: TIM图片20180815175301.png, TIM图片20180815175342.png,
> TIM图片20180815175407.png
>
>
> Kylin2.4
> 使用JDBC数据源，构建时通过Sqoop从mysql抽取数据到hive报错,split-by字段出现名重复：tablename.tablename.field
> sqoop-1.4.6/bin/sqoop import
> -Dorg.apache.sqoop.splitter.allow_text_splitter=true
> -Dmapreduce.job.queuename=default --connect
> "jdbc:mysql://192.168.31.108:3306/kylin_jdbcresource_test" --driver
> com.mysql.jdbc.Driver --username root --password root1324 --query "SELECT
> A.NAME as A_NAME ,A.CRT_DATE FROM KYLIN_JDBCRESOURCE_TEST.A as A WHERE 1=1
> AND (A.CRT_DATE >= '2018-08-01 00:00:00' AND A.CRT_DATE < '2018-08-16
> 00:00:00') AND \$CONDITIONS" --target-dir
> hdfs://localhost:9000/kylin/kylin_metadata/kylin-6bbe475b-ad11-4501-b3db-a56ee0222c90/kylin_intermediate_jdbc_resource_cube_7a4bd639_38ac_41be_9fba_6c64e040b175{color:#ff0000}
> --split-by A.A.CRT_DATE{color} --boundary-query "SELECT min(A.CRT_DATE),
> max(A.CRT_DATE) FROM "KYLIN_JDBCRESOURCE_TEST".A as A WHERE A.CRT_DATE >=
> '2018-08-01 00:00:00' AND A.CRT_DATE < '2018-08-16 00:00:00'" --null-string
> '' --fields-terminated-by '|' --num-mappers 1
> Caused by:
> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:{color:#ff0000}
> Unknown column 'A.A.CRT_DATE' in 'where clause'{color}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
