× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
Anilkumar Kalshetti
anilkalshetti reported 2015-08-19T06:43:28Z  · last modified 2015-08-19T11:31:35Z

Select Query, Result-Grid Tab- Unable to resize row id column, Row Id displayed as ellipsis

  Duplicates #11328
Dev
John LH
JohnLH
QA
Tariq Rahiman
tariqrahiman
Priority Low
Complexity Unknown
Component Hive
Version 17.0

Aqua Data Studio 17.0.0-alpha-21
Build #: 45303
Built on: 2015-Aug-18 08:33:52 PM     

OS: Ubuntu 14.04 LTE
Operating Environment: Linux (3.13.0-59-generic, amd64) / UTF-8 / en / IN / Oracle Corporation 1.8.0_40-b26
Memory: Max=4,433,379,328;  Total=4,430,233,600;  Free=1,390,231,640;  CPUs=8

RAM allocated to ADS application: 4.5GB 

Database: Hortonworks HDP 2.1 TP Hive 0.13- Drivers Link
Distribution : Hortonworks Connection Type: HiveServer2

Dataset File: stock.csv [Size: 111 MB] -Download Link
Shared Directory-QA-Dimentrix/AllDBDetails/Hive/Data/Stocks
 

Issue: Select Query Result-Grid Tab- Unable to resize row id column, row id greater than 10 Lakh is displayed as ellipsis[dotted format]

Steps to reproduce Issue:
1. In Query Analyzer, Execute below query to create a Table.

CREATE EXTERNAL TABLE IF NOT EXISTS stocks (
exchanges STRING,
symbol STRING,
ymd STRING,
price_open FLOAT,
price_high FLOAT,
price_low FLOAT,
price_close FLOAT,
volume INT,
price_adj_close FLOAT)
ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
LOCATION '/user/hive/stocks'
Go

2. As this is external table, we need to copy the data file to specified location- /user/hive/stocks/
3. Open browser, with URL: http://10.171.0.151:8000/   
//Use IP address of VM, where Hive is running in the above URL.
4. Click on file browser, inside '/user/hive/'  , create directory 'stocks'
5. Then upload the data file stocks.csv [116 MB]

6. In ADS, Query Analyzer, execute select query on table.
SELECT * FROM stocks
GO

7. In Results, Text Tab,  2075394 records are displayed properly. 
8. In Grid Tab, scroll down to Row Id - 11Lakh [1100000] , you will observe that, it is displayed as ellipsis[dotted format]

 - Even user is not able to resize Row Id column, to expand the column Row Id

@Dev:
1. Issue can be reproduced on any distribution.  The only thing is, it requires large dataset [above 10Lakh] 
2. I think, this issue can be reproduced on other databases too, if the data-records in table is larger than 10Lakh.

1 attachment
  •  
  •  
  • No shares
  •  
All Comments (0) Change History
Sort 

Issue #13681
Closed
Duplicate
Resolved 2015-08-19T11:31:35Z
 
 
Completion
No due date
No fixed build
No time estimate

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