#12196: Impala- ADS Visual editor, Create Table window Storage Tab, Stored As default parameter should be TEXTFILE

anilkalshetti reported 2014-05-26T08:38:28Z · last modified 2014-11-04T17:54:32Z

Impala- ADS Visual editor, Create Table window Storage Tab, Stored As default parameter should be TEXTFILE

Dev	tomconrad
QA	tariqrahiman

Priority	Low
Complexity	Unknown

Component	Hive
Version	16.0

Aqua Data Studio 15.0.0-dev-295
Build #: 38083
Built on: 2014-May-22 04:40:25 PM

Operating Environment: Ubuntu 13.04 LTS

Database: Cloudera Impala
CDH 5 VM , Connection Type: Impala , Port: 21050
Java Version: Java 1.7.0_51

Issue: Impala- ADS Visual editor, Create Table window Storage Tab, Stored As default parameter should be TEXTFILE

Steps to reproduce:

Start Cloudera Quickstart VM CDH5 [or you can use other Cloudera version ]

1. Register Servers with below credentials

a] To Register Impala Server:

Name: HS2CDH5Impala

Connection Type: Impala
Port : 21050

2. Open Query Analyzer and run below Query to create a Database.

CREATE DATABASE dbimpala

3. Right click on Tables, select Create Table. Create Table window opens

In General tab, enter table name and column names, click on 'Create' button.

Table gets created with storage file format SEQUENCEFILE.

//[USER has not selected any storage file format ]

4. If user runs the create table script, without mentioning storage file format, table gets created with TEXTFILE format.

create table val_test_1 (c1 int, c2 float, c3 string, c4 boolean, c5 timestamp)

So on similar ground, ADS Visual Editor, Create Table window, Storage tab, Stored As default parameter should be TEXTFILE.

1 attachment

Screenshot1.png

2014-05-26T08:38:28Z

318 KB

All Comments (8) Change History

anilkalshetti 2014-05-26T08:40:59Z

Ref. Link: http://www.cloudera.com/content/cloudera-content/cloudera-docs/CDH5/latest/Impala/Installing-and-Using-Impala/ciiu_file_formats.html#file_formats

Text files are convenient to produce through many different tools, and are human-readable for ease of verification and debugging. Those characteristics are why text is the default format for an Impala CREATE TABLE statement.

SachinPrakash 2014-05-27T16:22:40Z

@tom: only if this is a low impact change...

tomconrad 2014-07-01T20:51:08Z

Also ADS 14.0.17-2

anilkalshetti 2014-07-02T09:30:22Z

Verified in ADS 15.0.0-dev-361

anilkalshetti 2014-07-02T09:54:32Z

This improvement is applicable for all Hive distributions,
Logged new Improvement : Issue#12372

anilkalshetti 2014-07-02T10:03:39Z

Need to verify in ADS 14.0.18

anilkalshetti 2014-07-22T05:12:21Z

Verified in ADS 14.0.18
and ADS 15.0.0-alpha-17

anilkalshetti 2014-11-04T10:11:58Z

Verified in ADS 16.0.0-dev-21

Tested this issue in

Cloudera Quickstart VM CDH5.2 [Hive 0.13.1] , Connection Type: Impala

Search Tips

Aqua Data Studio / nhilam

Impala- ADS Visual editor, Create Table window Storage Tab, Stored As default parameter should be TEXTFILE

1 attachment

Issue #12196

Completion

1 issue link

Issue #12372

Search Tips

Aqua Data Studio / nhilam

Title

Impala- ADS Visual editor, Create Table window Storage Tab, Stored As default parameter should be TEXTFILE

1 attachment

Issue #12196

Completion

1 issue link

Issue #12372