× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
Anilkumar Kalshetti
anilkalshetti reported May 26, 2014  · tariqrahiman last modified Nov 4, 2014

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


Dev
Thomas Conrad
tomconrad
QA
Tariq Rahiman
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
GO
 
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)
Go
 
 
So on similar ground, ADS Visual Editor, Create Table window, Storage tab, Stored As default parameter should be TEXTFILE.
 
 
 
 
 
 
 

 

1 attachment
  •  
  •  
  • No shares
  •  
All (17) Comments Change History
Sort 
Sachin Prakash
SachinPrakash   May 27, 2014  Change History
Field Old Value New Value
Dev Assignee SachinPrakash (Sachin Prakash) tomconrad (Thomas Conrad)
Niels Gron
NielsGron   Jun 22, 2014  Change History
Field Old Value New Value
Dev Assignee tomconrad (Thomas Conrad) ivangron (Ivan Gron)
Niels Gron
NielsGron   Jun 23, 2014  Change History
Field Old Value New Value
Dev Assignee ivangron (Ivan Gron) tomconrad (Thomas Conrad)
Thomas Conrad
tomconrad   Jul 1, 2014  Change History
Field Old Value New Value
Fixed Build ADS 15.0.0-dev-360
Resolution Fixed
Resolved Date Jul 1, 2014 8:51 PM
Status New Resolved
Anilkumar Kalshetti
anilkalshetti   Jul 2, 2014  Change History
Field Old Value New Value
Status Resolved Verified
Anilkumar Kalshetti
anilkalshetti   Jul 2, 2014  Change History
Field Old Value New Value
Status Verified Resolved
Anilkumar Kalshetti
anilkalshetti   Jul 22, 2014  Change History
Field Old Value New Value
Status Resolved Verified
Niels Gron
NielsGron   Aug 22, 2014  Change History
Field Old Value New Value
Version 15.0 16.0
Tariq Rahiman
tariqrahiman   Nov 4, 2014  Change History
Field Old Value New Value
Status Verified Closed

Issue #12196
Closed
Fixed
Resolved Jul 1, 2014
 
 
Completion
No due date
Fixed Build ADS 15.0.0-dev-360
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017