[jira] [Created] (KYLIN-3989) Invalid temporary table path for kylin_metadata

["Frederic Souchu (JIRA)" <ji...@apache.org>]

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)