#12372: Hive All distributions- ADS Visual editor, Create Table window Storage Tab, Stored As default parameter should be TEXTFILE

anilkalshetti reported Jul 2, 2014 · tariqrahiman last modified Nov 4, 2014

Hive All distributions- 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-361
Build #: 38939
Built on: 2014-Jul-01 05:32:50 PM

Operating Environment: Ubuntu 13.04 LTS

Java Version: Java 1.7.0_60

Database: Hive

Applicable to all Hive Distributions

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

Steps to reproduce:

1. Connect to any Hive Distribution.

2. In Schema Tree node, 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 storageff (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.

This is applicable to all Hive Distributions
Distributions:

1. Apache

2. Cloudera

3. Hortonworks
4. MapR

Currently we have fixed this improvement for Cloudera Impala in Issue #12196

All (10) Comments Change History

anilkalshetti Jul 2, 2014 Comment

Need to do same changes as done for issue#12196

tomconrad Jul 2, 2014 Change History

Field	Old Value	New Value
Dev Assignee	JohnLH (John LH)	tomconrad (Thomas Conrad)

tomconrad Jul 2, 2014 Change History

Field	Old Value	New Value
Fixed Build		ADS 15.0.0-dev-363
Resolution		Fixed
Resolved Date		Jul 2, 2014 6:08 PM
Status	New	Resolved

tomconrad Jul 2, 2014 Comment

Also ADS 14.0.17-3

anilkalshetti Jul 7, 2014 Comment

Verified in ADS 15.0.0-dev-366

This issue is checked for all the hive distributions:

Distributions:

1. Apache

2. Cloudera

3. Hortonworks
4. MapR

Will check in build ADS 14.0.18 patch, when available

anilkalshetti Jul 22, 2014 Change History

Field	Old Value	New Value
Status	Resolved	Verified

anilkalshetti Jul 22, 2014 Comment

Verified in ADS 14.0.18
and ADS 15.0.0-alpha-17

For all Hive Distributions

Distributions:

1. Apache

2. Cloudera

3. Hortonworks
4. MapR

a]ADS Visual Editor Create Table, Storage Tab - Stored As: TEXTFILE - Pass
b]ER diagram Create Table, Storage Tab - Stored As: TEXTFILE- Pass

NielsGron Aug 22, 2014 Change History

Field	Old Value	New Value
Version	15.0	16.0

anilkalshetti Nov 4, 2014 Comment

Verified in ADS 16.0.0-dev-21

Tested this issue in below Hive Distributions

a] Apache Hive 0.13.1, Distribution: Apache, Connection Type: Hiveserver2

Apache Hive 0.13.1, Distribution: Apache, Connection Type: Hiveserver1

b] Hortonworks HDP2.1 Quickstart VM [Hive 0.13] , Distribution: Hortonworks, Connection Type: Hiveserver2

c] Cloudera Quickstart VM CDH5.2 [Hive 0.13.1] , Distribution: Cloudera, Connection Type: Hiveserver2

d] MapR-VM-4.0.1 [Hive 0.12] , Distribution: MapR, Connection Type: Hiveserver2

a]ADS Visual Editor Create Table, Storage Tab - Stored As: TEXTFILE - Pass
b]ER diagram Create Table, Storage Tab - Stored As: TEXTFILE- Pass

tariqrahiman Nov 4, 2014 Change History

Field	Old Value	New Value
Status	Verified	Closed

Search Tips

Aqua Data Studio / nhilam

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

Issue #12372

Completion

1 issue link

Issue #12196

Search Tips

Aqua Data Studio / nhilam

Title

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

Issue #12372

Completion

1 issue link

Issue #12196