[
https://issues.apache.org/jira/browse/SPARK-31170?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17088997#comment-17088997
]
Nicholas Chammas commented on SPARK-31170:
------------------------------------------
Isn't this also an issue in Spark 2.4.5?
{code:java}
$ spark-sql
...
20/04/21 15:12:26 INFO metastore: Mestastore configuration
hive.metastore.warehouse.dir changed from /user/hive/warehouse to
file:/Users/myusername/spark-warehouse
...
spark-sql> create table test(a int);
...
20/04/21 15:12:48 WARN HiveMetaStore: Location: file:/user/hive/warehouse/test
specified for non-external table:test
20/04/21 15:12:48 INFO FileUtils: Creating directory if it doesn't exist:
file:/user/hive/warehouse/test
Error in query: org.apache.hadoop.hive.ql.metadata.HiveException:
MetaException(message:file:/user/hive/warehouse/test is not a directory or
unable to create one);{code}
If I understood the problem correctly, then the fix should perhaps also be
backported to 2.4.x.
> Spark Cli does not respect hive-site.xml and spark.sql.warehouse.dir
> --------------------------------------------------------------------
>
> Key: SPARK-31170
> URL: https://issues.apache.org/jira/browse/SPARK-31170
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 3.0.0
> Reporter: Kent Yao
> Assignee: Kent Yao
> Priority: Major
> Fix For: 3.0.0
>
>
> In Spark CLI, we create a hive CliSessionState and it does not load the
> hive-site.xml. So the configurations in hive-site.xml will not take effects
> like other spark-hive integration apps.
> Also, the warehouse directory is not correctly picked. If the `default`
> database does not exist, the CliSessionState will create one during the first
> time it talks to the metastore. The `Location` of the default DB will be
> neither the value of spark.sql.warehousr.dir nor the user-specified value of
> hive.metastore.warehourse.dir, but the default value of
> hive.metastore.warehourse.dir which will always be `/user/hive/warehouse`.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
