The datasource is hive as described in the title
------------------ ???????? ------------------ ??????: "PENG Zhengshuai"<[email protected]>; ????????: 2019??3??6??(??????) ????2:07 ??????: "[email protected]"<[email protected]>; ????: Re: hive?????????? ??hive??table??????????????????build cube ?????? Hi, Let??s make sure the below things: 1. The datasource is hive or RDBMS? 2. If use RDBMS as datasource, which RDBMS? Mysql or Mssql 3. Do you have change some configurations like disable quote in sql? BR PENG Zhengshuai > On Mar 6, 2019, at 1:28 PM, ???????? <[email protected]> wrote: > > kylin??????sql????(??hive)?? > CREATE EXTERNAL TABLE IF NOT EXISTS > kylin_intermediate_ch_cube_5cc15555_a6f3_f9f8_b90a_3e52abe0760b > ( > ICSTOCKBILL_1W_C_????ID int > ,ICSTOCKBILL_1W_C_????ID int > ,ICSTOCKBILL_1W_C_???? timestamp > ,ICSTOCKBILL_1W_C_????ID int > ,GOODS_C_????ID int > ,GOODS_C_????ID int > ,DEPARTMENT_C_????ID int > ,DEPARTMENT_C_????ID int > ,GOODSCLASS_C_????ID int > ,DEPARTMENTCLASS_C_????ID int > ,ICSTOCKBILL_1W_C_???? int > ,ICSTOCKBILL_1W_C_?????? decimal(20,3) > ,ICSTOCKBILL_1W_C_?????? decimal(20,3) > ,ICSTOCKBILL_1W_C_???? decimal(20,3) > ,ICSTOCKBILL_1W_C_?????? decimal(20,3) > ) > STORED AS SEQUENCEFILE > > LOCATION > 'hdfs://kylincluster/kylin/kylin_metadata/kylin-6613a735-0452-1bd5-aa22-e63013366c2a/kylin_intermediate_ch_cube_5cc15555_a6f3_f9f8_b90a_3e52abe0760b'; > > > > ????????????FAILED: ParseException line 3:19 cannot recognize input near 'ID' > 'int' ',' in column type > > > > > ????????????hive sql????(?????????????????????????? ` ): > CREATE EXTERNAL TABLE IF NOT EXISTS > kylin_intermediate_ch_cube_5cc15555_a6f3_f9f8_b90a_3e52abe0760b > ( > `ICSTOCKBILL_1W_C_????ID` int > ,`ICSTOCKBILL_1W_C_????ID` int > ,`ICSTOCKBILL_1W_C_????` timestamp > ,`ICSTOCKBILL_1W_C_????ID` int > ,`GOODS_C_????ID` int > ,`GOODS_C_????ID` int > ,`DEPARTMENT_C_????ID` int > ,`DEPARTMENT_C_????ID` int > ,`GOODSCLASS_C_????ID` int > ,`DEPARTMENTCLASS_C_????ID` int > ,`ICSTOCKBILL_1W_C_????` int > ,`ICSTOCKBILL_1W_C_??????` decimal(20,3) > ,`ICSTOCKBILL_1W_C_??????` decimal(20,3) > ,`ICSTOCKBILL_1W_C_????` decimal(20,3) > ,`ICSTOCKBILL_1W_C_??????` decimal(20,3) > ) > STORED AS SEQUENCEFILE > > LOCATION > 'hdfs://kylincluster/kylin/kylin_metadata/kylin-6613a735-0452-1bd5-aa22-e63013366c2a/kylin_intermediate_ch_cube_5cc15555_a6f3_f9f8_b90a_3e52abe0760b'; > > > > > > > > ------------------ ???????? ------------------ > ??????: "PENG Zhengshuai"<[email protected]>; > ????????: 2019??3??6??(??????) ????1:09 > ??????: "[email protected]"<[email protected]>; > > ????: Re: hive?????????? ??hive??table??????????????????build cube ?????? > > > > Hi, > > Can you show the Hive Sql in Kylin.log when cube building? > > BR > PENG Zhengshuai > >> On Mar 5, 2019, at 3:25 PM, ???????? <[email protected]> wrote: >> >> Hi, >> hive?????????? ??hive??table??????????????????build cube ?????? >> kylin2.6.0 hadoop3 >> ?????????? >> >> >> NoViableAltException(24@[]) at >> org.apache.hadoop.hive.ql.parse.HiveParser.type(HiveParser.java:36813) >> at org.apache.hadoop.hive.ql.parse.HiveParser.colType(HiveParser.java:36595) >> at >> org.apache.hadoop.hive.ql.parse.HiveParser.columnNameTypeConstraint(HiveParser.java:34322) >> at >> org.apache.hadoop.hive.ql.parse.HiveParser.columnNameTypeOrConstraint(HiveParser.java:34075) >> at >> org.apache.hadoop.hive.ql.parse.HiveParser.columnNameTypeOrConstraintList(HiveParser.java:29819) >> at >> org.apache.hadoop.hive.ql.parse.HiveParser.createTableStatement(HiveParser.java:6662) >> at >> org.apache.hadoop.hive.ql.parse.HiveParser.ddlStatement(HiveParser.java:4295) >> at >> org.apache.hadoop.hive.ql.parse.HiveParser.execStatement(HiveParser.java:2494) >> at >> org.apache.hadoop.hive.ql.parse.HiveParser.statement(HiveParser.java:1420) >> at org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:220) >> at org.apache.hadoop.hive.ql.parse.ParseUtils.parse(ParseUtils.java:74) >> at >> org.apache.hadoop.hive.ql.parse.ParseUtils.parse(ParseUtils.java:67) >> at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:616) at >> org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:1826) at >> org.apache.hadoop.hive.ql.Driver.compileAndRespond(Driver.java:1773) >> at org.apache.hadoop.hive.ql.Driver.compileAndRespond(Driver.java:1768) >> at >> org.apache.hadoop.hive.ql.reexec.ReExecDriver.compileAndRespond(ReExecDriver.java:126) >> at >> org.apache.hadoop.hive.ql.reexec.ReExecDriver.run(ReExecDriver.java:214) >> at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:239) >> at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:188) >> at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:402) >> at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:335) >> at >> org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:787) >> at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:759) at >> org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:683) 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.apache.hadoop.util.RunJar.run(RunJar.java:318) at >> org.apache.hadoop.util.RunJar.main(RunJar.java:232) FAILED: ParseException >> line 4:19 cannot recognize input near 'ID' 'int' ',' in column type The >> command is: hive -e "USE default; DROP TABLE IF EXISTS >> kylin_intermediate_ch_cube_5cc15555_a6f3_f9f8_b90a_3e52abe0760b; CREATE >> EXTERNAL TABLE IF NOT EXISTS >> kylin_intermediate_ch_cube_5cc15555_a6f3_f9f8_b90a_3e52abe0760b ( >> ICSTOCKBILL_1W_C_????ID int ,ICSTOCKBILL_1W_C_????ID int >> ,ICSTOCKBILL_1W_C_???? timestamp ,ICSTOCKBILL_1W_C_????ID int >> ,GOODS_C_????ID int ,GOODS_C_????ID int ,DEPARTMENT_C_????ID int >> ,DEPARTMENT_C_????ID int ,GOODSCLASS_C_????ID int ,DEPARTMENTCLASS_C_????ID >> int ,ICSTOCKBILL_1W_C_???? int ,ICSTOCKBILL_1W_C_?????? decimal(20,3) >> ,ICSTOCKBILL_1W_C_?????? decimal(20,3) ,ICSTOCKBILL_1W_C_???? decimal(20,3) >> ,ICSTOCKBILL_1W_C_?????? decimal(20,3) ) STORED AS SEQUENCEFILE LOCATION >> 'hdfs://kylincluster/kylin/kylin_metadata/kylin-6613a735-0452-1bd5-aa22-e63013366c2a/kylin_intermediate_ch_cube_5cc15555_a6f3_f9f8_b90a_3e52abe0760b'; >> ??kylin???????????????? ???????? `?? >> >> >> ?????????????????????????? `??????????????sql???????????????? >> ??????sql?????????? >> CREATE EXTERNAL TABLE IF NOT EXISTS >> kylin_intermediate_ch_cube_5cc15555_a6f3_f9f8_b90a_3e52abe0760b >> ( >> `ICSTOCKBILL_1W_C_mdID` int >> ,`ICSTOCKBILL_1W_C_khID` int >> ,`ICSTOCKBILL_1W_C_sj` timestamp >> ,`ICSTOCKBILL_1W_C_spID` int >> ,`GOODS_C_spID` int >> ,`GOODS_C_plID` int >> ,`DEPARTMENT_C_mdID` int >> ,`DEPARTMENT_C_qyuID` int >> ,`GOODSCLASS_C_plID` int >> ,`DEPARTMENTCLASS_C_quyID` int >> ,`ICSTOCKBILL_1W_C_shul` int >> ,`ICSTOCKBILL_1W_C_jhj` decimal(20,3) >> ,`ICSTOCKBILL_1W_C_zsj` decimal(20,3) >> ,`ICSTOCKBILL_1W_C_sj` decimal(20,3) >> ,`ICSTOCKBILL_1W_C_zcb` decimal(20,3) >> ) >> STORED AS SEQUENCEFILE; >> >> >> >> ?????????????????????????? >> >> >> Best regards >> -- >> Regards! >> Aron Tao
