[DRILL-1667] storageformat is deprecated but still appears in the default dfs configuration

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.6.0
• Fix Version/s: 0.7.0

Environment

Embedded mode on Mac OSX, running latest 0.6 release

• Assignee: Sean Hsuan-Yi Chu
• Reporter: Bob Rumsby
• Created: 10/Nov/14 01:12
• Updated: 18/Nov/14 18:46
• Resolved: 18/Nov/14 18:45

Description

The default workspaces for DFS still show "storageformat" although this setting is deprecated.
{
"type": "file",
"enabled": true,
"connection": "file:///",
"workspaces": {
"root":

{ "location": "/", "writable": false, "storageformat": null }

,
"tmp":

{ "location": "/tmp", "writable": true, "storageformat": "csv" }

Here is a related email thread from 10/15:

My understanding when I wrote the CTAS description was that the alter option would be deprecated and the storageformat would work in the plugin.

On Wed, Oct 15, 2014 at 4:07 PM, Andries Engelbrecht <[e-mail]> wrote:
Thx, the alter session setting worked.

Unfortunately it is not in the documentation as a session option.
https://cwiki.apache.org/confluence/display/DRILL/Planning+and+Execution+Options

And seems to contradict the documentation as to how the format is set.
https://cwiki.apache.org/confluence/display/DRILL/CREATE+TABLE+AS+%28CTAS%29+Command

On Wed, Oct 15, 2014 at 3:37 PM, Steven Phillips <[e-mail]> wrote:
yeah, this setting in workspace is deprecated, and should be removed.

On Wed, Oct 15, 2014 at 3:32 PM, Chun Chang <[e-mail]> wrote:
You will need to set the store.format to your desired format. For example, to create table stored in json format, do the following:

0: jdbc:drill:zk=local> alter session set `store.format` = 'json';

Issue Links

• depends upon: DRILL-1540 Provide a fallback data format in case Drill is unable to determine one