[
https://issues.apache.org/jira/browse/KYLIN-3500?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
cqli updated KYLIN-3500:
------------------------
Description:
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}
was:
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}
Summary: Unknown column 'A.A.CRT_DATE' in 'where clause' (was:
Kylin2.4
使用JDBC数据源，构建时通过Sqoop从mysql抽取数据到hive报错,split-by字段出现名重复：tablename.tablename.field)
> 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
>
> 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)
