[SPARK-16825] Replace hive.default.fileformat by spark.sql.default.fileformat

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Won't Fix
• Affects Version/s: 2.0.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Xiao Li
• Created: 31/Jul/16 21:08
• Updated: 26/Sep/19 14:05
• Resolved: 07/Nov/16 20:29

Description

Currently, we are using hive.default.fileformat for specifying the default file format in CREATE TABLE statement. Multiple issues exist:

• This parameter value is not from `hive-site.xml`. Thus, even if users change the hive.default.fileformat in `hive-site.xml`, Spark will ignore it. To change the parameter values, users have to use Spark interface, (e.g., by a SET command or API).
• This parameter is not documented.
• This parameter value will not be sent to Hive metastore. It is being used by Spark internals when processing CREATE TABLE statement.
• This parameter is case sensitive.

Since this is being used by Spark only, it does not make sense to use a parameter starting from `hive`. we might follow the other Hive-related parameters and introduce a new Spark parameter here. It should be public. Thus, how about replacing `hive.default.fileformat` by `spark.sql.default.fileformat`. we also should make it case insensitive.

Issue Links

• relates to: SPARK-21067 Thrift Server - CTAS fail with Unable to move source
• links to: [Github] Pull Request #14430 (gatorsmile)
• links to: GitHub Pull Request #14430