It seems the sample fact table "KYLIN_SALES" table wasn't successfully created in hive; please check hive and try to rerun "./bin/sample.sh" to see whether there is any error message;
2015-10-16 6:01 GMT+08:00 KylinPOC <[email protected]>: > 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. >
