kylin-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Shaofeng SHI (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (KYLIN-3500) kylin 2.4 use jdbc datasource :Unknown column 'A.A.CRT_DATE' in 'where clause'
Date Thu, 16 Aug 2018 06:52:00 GMT

    [ https://issues.apache.org/jira/browse/KYLIN-3500?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16582047#comment-16582047
] 

Shaofeng SHI commented on KYLIN-3500:
-------------------------------------

[~zhanshaoxiong] shaoxiong, could you help to check this?

> 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
>         Environment: Hadoop2.7.6+Hive-1.2.2+HBase1.2.6+Sqoop1.4.7
>            Reporter: cqli
>            Priority: Major
>         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)

Mime
View raw message