kylin-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From 徐 鹏 <xupeng1...@outlook.com>
Subject Re: kylin_sales_cube fails to build on first step
Date Wed, 14 Dec 2016 05:32:23 GMT
can you see these table by hive client/beeline
在 2016年12月14日,下午1:26,John Ruiz <jruiz@johnruiz.com<mailto:jruiz@johnruiz.com>>
写道:

Hello!

I've run $KYLIN_HOME/bin/sample.sh and then attempted to build the cube.  It fails on step
1 saying that the KYLIN_SALES table doesn't exist.  The output is below.  If I go to the Data
Source tab in the learn_kylin project, I can see that the default database does have a KYLIN_SALES
table, though.

kylin 1.6.0
hive 2.1.1
hbase 1.2.4
hadoop-core 2.6.0

Create and distribute table, cmd:
hive -e "SET dfs.replication=2;
SET hive.exec.compress.output=true;
SET hive.auto.convert.join.noconditionaltask=true;
SET hive.auto.convert.join.noconditionaltask.size=100000000;
SET mapreduce.output.fileoutputformat.compress.type=BLOCK;
SET mapreduce.job.split.metainfo.maxsize=-1;

USE default;
DROP TABLE IF EXISTS kylin_intermediate_kylin_sales_cube_desc_e09d95b1_c060_4020_b053_deb4d1c6645e;
CREATE EXTERNAL TABLE IF NOT EXISTS kylin_intermediate_kylin_sales_cube_desc_e09d95b1_c060_4020_b053_deb4d1c6645e
(
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_USER_ID string
,DEFAULT_KYLIN_SALES_REGION string
,DEFAULT_KYLIN_SALES_PRICE decimal(19,4)
,DEFAULT_KYLIN_SALES_SELLER_ID bigint
)
STORED AS SEQUENCEFILE
LOCATION '/kylin/kylin_metadata/kylin-c6867cdb-7267-456e-b987-8900a3d42b74/kylin_intermediate_kylin_sales_cube_desc_e09d95b1_c060_4020_b053_deb4d1c6645e';
SET dfs.replication=2;
SET hive.exec.compress.output=true;
SET hive.auto.convert.join.noconditionaltask=true;
SET hive.auto.convert.join.noconditionaltask.size=100000000;
SET mapreduce.output.fileoutputformat.compress.type=BLOCK;
SET mapreduce.job.split.metainfo.maxsize=-1;
INSERT OVERWRITE TABLE kylin_intermediate_kylin_sales_cube_desc_e09d95b1_c060_4020_b053_deb4d1c6645e
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.USER_ID
,KYLIN_SALES.REGION
,KYLIN_SALES.PRICE
,KYLIN_SALES.SELLER_ID
FROM DEFAULT.KYLIN_SALES as KYLIN_SALES
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 < '2016-12-01')
;

"
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/usr/local/hive/lib/log4j-slf4j-impl-2.4.1.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/usr/local/hadoop/share/hadoop/common/lib/slf4j-log4j12-1.7.5.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.apache.logging.slf4j.Log4jLoggerFactory]

Logging initialized using configuration in jar:file:/usr/local/hive/lib/hive-common-2.1.1.jar!/hive-log4j2.properties
Async: true
OK
Time taken: 0.702 seconds
OK
Time taken: 0.07 seconds
OK
Time taken: 0.528 seconds
FAILED: SemanticException [Error 10001]: Line 14:5 Table not found 'KYLIN_SALES'

Mime
View raw message