× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
Anilkumar Kalshetti
anilkalshetti reported 2015-08-19T10:08:21Z  · tariqrahiman last modified 2017-05-18T21:06:50Z

'Select *' Query, Result-Text Tab- All the records available in Table are not displayed


Dev
Thomas Conrad
tomconrad
QA
Tariq Rahiman
tariqrahiman
Priority Low
Complexity Unknown
Component Hive
Version 19.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: wdi_data.tsv.gz [28 MB]
Shared Directory-QA-Dimentrix/AllDBDetails/Hive/Data/wdi
 

Issue: 'Select *' Query Result-Text Tab- All the records available in Table are not displayed

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

CREATE EXTERNAL TABLE wdi     
(
country_name     STRING,
country_code     STRING,
 indicator_name     STRING,     
  indicator_code     STRING,
  `1960` FLOAT,     `1961` FLOAT,     `1962` FLOAT,     `1963` FLOAT,     `1964` FLOAT,
  `1965` FLOAT,     `1966` FLOAT,     `1967` FLOAT,     `1968` FLOAT,     `1969` FLOAT,
  `1970` FLOAT,     `1971` FLOAT,     `1972` FLOAT,     `1973` FLOAT,     `1974` FLOAT,
  `1975` FLOAT,     `1976` FLOAT,     `1977` FLOAT,     `1978` FLOAT,     `1979` FLOAT,
  `1980` FLOAT,     `1981` FLOAT,     `1982` FLOAT,     `1983` FLOAT,     `1984` FLOAT,
  `1985` FLOAT,     `1986` FLOAT,     `1987` FLOAT,     `1988` FLOAT,     `1989` FLOAT,
  `1990` FLOAT,     `1991` FLOAT,     `1992` FLOAT,     `1993` FLOAT,     `1994` FLOAT,
  `1995` FLOAT,     `1996` FLOAT,     `1997` FLOAT,     `1998` FLOAT,     `1999` FLOAT,
  `2000` FLOAT,     `2001` FLOAT,     `2002` FLOAT,     `2003` FLOAT,     `2004` FLOAT,
  `2005` FLOAT,     `2006` FLOAT,     `2007` FLOAT,     `2008` FLOAT,     `2009` FLOAT,
  `2010` FLOAT,     `2011` FLOAT,     `2012` FLOAT
)
ROW     FORMAT     DELIMITED     FIELDS     TERMINATED     BY '\t'
LOCATION     '/user/hive/wdi'

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 'wdi'
5. Then in wdi folder, upload the data file : wdi_data.tsv.gz [28 MB]

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

Issue->
7. In Results, Text Tab, Only half of the records are displayed. Number of records changes to 60 or 80% if we re-execute the query.
8. In Results, Grid Tab, all records in Table displayed properly.
9. In contrast, on same table, if we execute , 'select column-name' query, it displays all records properly in Results-Text Tab.
Please refer screenshot1.png

Observations:
1. Issue observed on all Hive distributions - [Cloudera, Hortonworks]
2.Issue also observed on ADSv16.0.5-24 build
2 attachments
  •  
  •  
  • 1 share
  •  
All Comments (4) Change History
Sort 

Issue #13684
Closed
Unreproducible
Resolved 2017-04-20T20:38:53Z
 
 
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