You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by "Yaqian Zhang (JIRA)" <ji...@apache.org> on 2019/07/31 02:30:00 UTC
[jira] [Commented] (KYLIN-3989) Invalid temporary table path for
kylin_metadata
[ https://issues.apache.org/jira/browse/KYLIN-3989?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16896706#comment-16896706 ]
Yaqian Zhang commented on KYLIN-3989:
-------------------------------------
Hi Frederic,
Sorry for late. You answered yourself question very well. Now do you have any other questions?
> 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
> Priority: Major
>
> 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.14#76016)