The error "Table not found 'KYLIN_CATEGORY_GROUPINGS'" indicates the sample hive tables were not successfully created in hive; You need re-run 'bin/sample.sh' and check whether there is any error messages;
2016-06-09 19:51 GMT+08:00 Punit Naik <naik.puni...@gmail.com>: > Hi > > I am trying Kylin for the very first time. I was following the intructions > on the homepage of Kylin about generating a sample cube. After running > sample.sh I tried to build the kylin_sales_cube. But when I executed the > job I got the following error at step 1 of the job: > > OS command error exit with 64 -- hive -e "USE default; > DROP TABLE IF EXISTS > kylin_intermediate_kylin_sales_cube_desc_20120101000000_20140909052500; > > CREATE EXTERNAL TABLE IF NOT EXISTS > kylin_intermediate_kylin_sales_cube_desc_20120101000000_20140909052500 > ( > 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-ec031b80-1d88-4f79-ab8d-29d9053a3b5e/kylin_intermediate_kylin_sales_cube_desc_20120101000000_20140909052500'; > > SET dfs.replication=2; > SET dfs.block.size=33554432; > SET hive.exec.compress.output=true; > SET hive.auto.convert.join.noconditionaltask=true; > SET hive.auto.convert.join.noconditionaltask.size=300000000; > SET > mapreduce.map.output.compress.codec=org.apache.hadoop.io.compress.SnappyCodec; > SET > mapreduce.output.fileoutputformat.compress.codec=org.apache.hadoop.io.compress.SnappyCodec; > SET hive.merge.mapfiles=true; > SET hive.merge.mapredfiles=true; > SET mapred.output.compression.type=BLOCK; > SET hive.merge.size.per.task=256000000; > SET hive.support.concurrency=false; > SET mapreduce.job.split.metainfo.maxsize=-1; > > INSERT OVERWRITE TABLE > kylin_intermediate_kylin_sales_cube_desc_20120101000000_20140909052500 SELECT > KYLIN_SALES.PART_DT > ,KYLIN_SALES.LEAF_CATEG_ID > ,KYLIN_SALES.LSTG_SITE_ID > ,KYLIN_CATEGORY_GROUPINGS.META_CATEG_NAME > ,KYLIN_CATEGORY_GROUPINGS.CATEG_LVL2_NAME > ,KYLIN_CATEGORY_GROUPINGS.CATEG_LVL3_NAME > ,KYLIN_SALES.LSTG_FORMAT_NAME > ,KYLIN_SALES.PRICE > ,KYLIN_SALES.SELLER_ID > FROM DEFAULT.KYLIN_SALES as KYLIN_SALES > INNER JOIN DEFAULT.KYLIN_CAL_DT as KYLIN_CAL_DT > ON KYLIN_SALES.PART_DT = KYLIN_CAL_DT.CAL_DT > INNER JOIN DEFAULT.KYLIN_CATEGORY_GROUPINGS as KYLIN_CATEGORY_GROUPINGS > ON KYLIN_SALES.LEAF_CATEG_ID = KYLIN_CATEGORY_GROUPINGS.LEAF_CATEG_ID AND > KYLIN_SALES.LSTG_SITE_ID = KYLIN_CATEGORY_GROUPINGS.SITE_ID > WHERE (KYLIN_SALES.PART_DT >= '2012-01-01' AND KYLIN_SALES.PART_DT < > '2014-09-09') > ; > > " > > Logging initialized using configuration in > jar:file:/home/test/fcstack/apache-hive-0.14.0-bin/lib/hive-common-0.14.0.jar!/hive-log4j.properties > SLF4J: Class path contains multiple SLF4J bindings. > SLF4J: Found binding in > [jar:file:/home/test/fcstack/hadoop-2.4.0/share/hadoop/common/lib/slf4j-log4j12-1.7.5.jar!/org/slf4j/impl/StaticLoggerBinder.class] > SLF4J: Found binding in > [jar:file:/home/test/fcstack/apache-hive-0.14.0-bin/lib/hive-jdbc-0.14.0-standalone.jar!/org/slf4j/impl/StaticLoggerBinder.class] > SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an > explanation. > SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory] > OK > Time taken: 0.48 seconds > OK > Time taken: 0.121 seconds > OK > Time taken: 0.682 seconds > FAILED: SemanticException Line 0:-1 Table not found 'KYLIN_CATEGORY_GROUPINGS' > > > Someone please help! > > -- > Thank You > > Regards > > Punit Naik > -- Best regards, Shaofeng Shi
