Uploaded image for project: 'Kylin'
  1. Kylin
  2. KYLIN-1930

Sample code - Building Model failed with error

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: v1.5.2
    • Fix Version/s: v1.5.2
    • Component/s: Query Engine
    • Labels:
      None
    • Environment:
      Hadoop 2.6.0
      Hbase 1.0.3
      Hive 1.2.1

      Description

      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:

        Attachments

          Activity

            People

            • Assignee:
              liyang.gmt8@gmail.com liyang
              Reporter:
              ranga123 Ranga
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: