Frederic Souchu created KYLIN-3989:
--------------------------------------
Summary: Invalid temporary table path for kylin_metadata
Key: KYLIN-3989
URL: https://issues.apache.org/jira/browse/KYLIN-3989
Project: Kylin
Issue Type: Bug
Affects Versions: v2.5.2
Environment: MapR 6.1
Hive 2.3
Reporter: Frederic Souchu
How to reproduce:
* create a mode
* define a cube
* build the cube
The cube building will fail with the following Hive logs:
{code:java}
USE default;
No rows affected (0.067 seconds)
0: jdbc:hive2://xxxxx.com>
0: jdbc:hive2://xxxxx.com> DROP TABLE IF EXISTS
kylin_intermediate_txn_cube_99023bdd_79e8_1186_2480_28b1d352d09e;
No rows affected (0.023 seconds)
0: jdbc:hive2://xxxxx.com> CREATE EXTERNAL TABLE IF NOT EXISTS
kylin_intermediate_txn_cube_99023bdd_79e8_1186_2480_28b1d352d09
e
. . . . . . . . . . . . . . . . . . . . . . .> (
. . . . . . . . . . . . . . . . . . . . . . .> PAYMENTS_GLOBALMERCHANTUID int
. . . . . . . . . . . . . . . . . . . . . . .> )
. . . . . . . . . . . . . . . . . . . . . . .> STORED AS SEQUENCEFILE
. . . . . . . . . . . . . . . . . . . . . . .> LOCATION
'maprfs:///apps/kylin_metadata/kylin-15b76d79-29ce-5782-d84e-bd33c305fc6f/kylin_intermedia
te_txn_cube_99023bdd_79e8_1186_2480_28b1d352d09e';
Error: org.apache.hive.service.cli.HiveSQLException: Error while processing
statement: FAILED: Execution Error, return code 1 from
org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:Got exception:
java.io.IOException Error: Not a directory(20), file:
kylin_intermediate_txn_cube_99023bdd_79e8_1186_2480_28b1d352d09e, user name:
mapr, ID: 5000)
{code}
using metastore.sh to list content gives:
{code}
2019-04-26 15:25:54,231 INFO [main] common.KylinConfig:100 : Loading
kylin-defaults.properties from
file:/opt/apache-kylin-2.5.2-bin-hbase1x/tool/kylin-tool-2.5.2.jar!/kylin-defaults.properties
2019-04-26 15:25:54,257 DEBUG [main] common.KylinConfig:327 : KYLIN_CONF
property was not set, will seek KYLIN_HOME env variable
2019-04-26 15:25:54,263 INFO [main] common.KylinConfig:135 : Initialized a new
KylinConfig from getInstanceFromEnv : 453523494
2019-04-26 15:25:54,376 INFO [main] persistence.ResourceStore:88 : Using
metadata url /apps/kylin_metadata@hbase for resource store
2019-04-26 15:25:55,684 DEBUG [main] hbase.HBaseConnection:180 : Using the
working dir FS for HBase: maprfs:///
2019-04-26 15:25:55,684 INFO [main] hbase.HBaseConnection:257 : connection is
null or closed, creating a new one
2019-04-26 15:25:55,719 INFO [main] client.ConnectionFactory:272 :
ConnectionFactory receives mapr.hbase.default.db(maprdb), set
clusterType(MAPR_ONLY), user(mapr), hbase_admin_connect_at_construction(false)
2019-04-26 15:25:55,899 DEBUG [main] hbase.HBaseConnection:306 : HTable
'/apps/kylin_metadata' already exists
null
2019-04-26 15:25:56,400 INFO [close-hbase-conn] hbase.HBaseConnection:136 :
Closing HBase connections...
{code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
