[jira] [Commented] (KYLIN-1930) Sample code - Building Model failed with error

["Billy(Yiming) Liu (JIRA)" <ji...@apache.org>]

    [ 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)