Product: Aqua Data Studio
Version: 15.0.0-dev-319
Build #: 38459
Build Date: 2014-Jun-12 10:58:44 AM
Operating Environment: Windows 7 (6.1, amd64) / Cp1252 / en / US / Oracle Corporation 1.7.0_40-b43
Memory: Max=704,643,072; Total=661,127,168; Free=269,092,576; CPUs=8
Database: Apache Hive 0.12
Distribution: Cloudera 5 Connection type:Hiveserver2
Steps to reproduce:
1)Right click on database node & select Query analyzer
2)Execute below script in query analyzer
CREATE TABLE demo.ean (
datekey int,
accountindx string,
accountid string,
deviceindx string,
deviceid string,
buildindx string,
build string,
ean string,
eanindx string,
duration bigint)
ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n'
STORED AS INPUTFORMAT 'org.apache.hadoop.mapred.TextInputFormat' OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
Location '/user/cloudera/eanduration'
GO
3)Right click on databases node & select Fluidshell
4)Execute below fluidshell command
sqldump -TS false -o tablestorage1.txt
5)Open file & you will observe that location of table is not present in create table script
Go to Fluidshell & Execute below command
sqldump -TS true -o tablestorage1.txt
6)Open file & You will observe that location of table is not present in Create table script
Sqldump command for table storage is not working properly
Please refer attached screenshots (true.png & false.png)
