Kylin creates intermediate table by shell command, you could check
your local hive client configuration.
在 15/10/13 上午8:42, LIU Ze (刘则) 写道:
hi all,
Hive use hdfs: A, Hbase use hdfs :B
when create table the location is used hdfs B, why?
CREATE EXTERNAL TABLE IF NOT EXISTS
kylin_intermediate_cubletest_20150101000000_20151031000000_e7f72ad9_77ca_4b1f_a8f8_fb54c1475885
(
FFAN_WEB_VISIT_DAY_DATEKEY string
,FFAN_DIM_DAY_MONTHKEY string
,FFAN_WEB_VISIT_DAY_VISIT_TYPE string
,FFAN_WEB_VISIT_DAY_MEMBER_TYPE string
,FFAN_WEB_VISIT_DAY_SOURCE string
,FFAN_WEB_VISIT_DAY_PV int
,FFAN_WEB_VISIT_DAY_UV int
,FFAN_WEB_VISIT_DAY_VISIT_CNT int
,FFAN_WEB_VISIT_DAY_IP_CNT int
)
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\177'
STORED AS SEQUENCEFILE
LOCATION
'/tmp/kylin/kylin_metadata//kylin-e7f72ad9-77ca-4b1f-a8f8-fb54c1475885/kylin_intermediate_cubletest_20150101000000_20151031000000_e7f72ad9_77ca_4b1f_a8f8_fb54c1475885';
________________________________
--
-------
Wei Hu
