[ https://issues.apache.org/jira/browse/KYLIN-1930?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15400894#comment-15400894 ]
Billy(Yiming) Liu commented on KYLIN-1930: ------------------------------------------ Error code 17 mostly means the job was kill by system. Please check the log in YARN, you may find not enough memory allocated for the job. > Sample code - Building Model failed with error > ----------------------------------------------- > > Key: KYLIN-1930 > URL: https://issues.apache.org/jira/browse/KYLIN-1930 > Project: Kylin > Issue Type: Bug > Components: Query Engine > Affects Versions: v1.5.2 > Environment: Hadoop 2.6.0 > Hbase 1.0.3 > Hive 1.2.1 > Reporter: Ranga > Assignee: liyang > Fix For: v1.5.2 > > > After importing Sales tables to HIVE using sample.sh > I tried to build kylin_samples_cube mode ->Action->Build. > It failed with following error. > I verified all tables and data exists in HIVE, I could not get what this > error mean and how to debug further to make sample code work. > Could you check this bug and let me know. > ERROR: > -------------------------------------------- > S command error exit with 17 -- hive -e "USE default; > DROP TABLE IF EXISTS > kylin_intermediate_kylin_sales_cube_desc_20120101000000_20120330195500; > CREATE EXTERNAL TABLE IF NOT EXISTS > kylin_intermediate_kylin_sales_cube_desc_20120101000000_20120330195500 > ( > 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-82b22a23-4262-4930-970d-a413cf245475/kylin_intermediate_kylin_sales_cube_desc_20120101000000_20120330195500'; > 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_20120330195500 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 < > '2012-03-30') > ; > " > Logging initialized using configuration in > jar:file:/usr/local/hive/lib/hive-common-1.2.1.jar!/hive-log4j.properties > OK > Time taken: 1.118 seconds > OK > Time taken: 0.107 seconds > OK > Time taken: 0.777 seconds > FAILED: SemanticException [Error 10001]: Line 13:5 Table not found > 'KYLIN_SALES' > ERROR: -- This message was sent by Atlassian JIRA (v6.3.4#6332)