[ 
https://issues.apache.org/jira/browse/KYLIN-3989?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16836148#comment-16836148
 ] 

Frederic Souchu commented on KYLIN-3989:
----------------------------------------

No effect - tried:
{code:java}
maprfs:///apps/kylin/
/apps/kylin/{code}

The setting seems to be completely ignored (except for this HBase log line  - 
seems incorrect as well since HBase is actually working in 
/apps/kylin_metadata!!).

> 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.3#76005)

Reply via email to