Kylin Team, While trying to build the sample cube, build fails at Step 1. FAILED: SemanticException [Error 10001]: Line 12:5 Table not found 'KYLIN_SALES'
Below is the entire error log. OS command error exit with 17 -- hive -e "USE default; DROP TABLE IF EXISTS kylin_intermediate_kylin_sales_cube_desc_19700101000000_20140305000000_64986016_b1dd_41a2_a760_679f06e5a36f; CREATE EXTERNAL TABLE IF NOT EXISTS kylin_intermediate_kylin_sales_cube_desc_19700101000000_20140305000000_64986016_b1dd_41a2_a760_679f06e5a36f ( DEFAULT_KYLIN_SALES_PART_DT date ,DEFAULT_KYLIN_SALES_LEAF_CATEG_ID bigint ,DEFAULT_KYLIN_SALES_LSTG_SITE_ID int ,DEFAULT_KYLIN_CATEGORY_GROUPINGS_META_CATEG_NAME string ,DEFAULT_KYLIN_CATEGORY_GROUPINGS_CATEG_LVL2_NAME string ,DEFAULT_KYLIN_CATEGORY_GROUPINGS_CATEG_LVL3_NAME string ,DEFAULT_KYLIN_SALES_LSTG_FORMAT_NAME string ,DEFAULT_KYLIN_SALES_PRICE decimal(19,4) ,DEFAULT_KYLIN_SALES_SELLER_ID bigint ) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\177' STORED AS SEQUENCEFILE LOCATION '/kylin/kylin_metadata//kylin-64986016-b1dd-41a2-a760-679f06e5a36f/kylin_intermediate_kylin_sales_cube_desc_19700101000000_20140305000000_64986016_b1dd_41a2_a760_679f06e5a36f'; SET mapreduce.job.split.metainfo.maxsize=-1; SET mapreduce.job.max.split.locations=2000; SET dfs.replication=2; SET hive.exec.compress.output=true; SET hive.auto.convert.join.noconditionaltask = true; SET hive.auto.convert.join.noconditionaltask.size = 300000000; INSERT OVERWRITE TABLE kylin_intermediate_kylin_sales_cube_desc_19700101000000_20140305000000_64986016_b1dd_41a2_a760_679f06e5a36f SELECT FACT_TABLE.PART_DT ,FACT_TABLE.LEAF_CATEG_ID ,FACT_TABLE.LSTG_SITE_ID ,LOOKUP_2.META_CATEG_NAME ,LOOKUP_2.CATEG_LVL2_NAME ,LOOKUP_2.CATEG_LVL3_NAME ,FACT_TABLE.LSTG_FORMAT_NAME ,FACT_TABLE.PRICE ,FACT_TABLE.SELLER_ID FROM DEFAULT.KYLIN_SALES as FACT_TABLE INNER JOIN DEFAULT.KYLIN_CAL_DT as LOOKUP_1 ON FACT_TABLE.PART_DT = LOOKUP_1.CAL_DT INNER JOIN DEFAULT.KYLIN_CATEGORY_GROUPINGS as LOOKUP_2 ON FACT_TABLE.LEAF_CATEG_ID = LOOKUP_2.LEAF_CATEG_ID AND FACT_TABLE.LSTG_SITE_ID = LOOKUP_2.SITE_ID WHERE (FACT_TABLE.PART_DT < '2014-03-05') ; " Logging initialized using configuration in jar:file:/usr/local/hive/lib/hive-common-1.2.1.jar!/hive-log4j.properties OK Time taken: 1.056 seconds OK Time taken: 0.107 seconds OK Time taken: 0.567 seconds FAILED: SemanticException [Error 10001]: Line 12:5 Table not found 'KYLIN_SALES' ==================================================================================== Enviornment: Hadoop 2.6 (pseudo mode) Hive 1.12 HBase 0.98 Thanks, SK -- View this message in context: http://apache-kylin-incubating.74782.x6.nabble.com/Sample-cube-build-fails-at-Step-1-tp1978.html Sent from the Apache Kylin (Incubating) mailing list archive at Nabble.com.
