Hive table showing the count and not displaying the data

[#1]

Dear community members,

i am not able see the hive table data while running select query , count query showing the count number. no errors were observed in the logs :

create table syntax:

CREATE TABLE `demandpriority`(

`demandtypekey` int,

`itemkey` int,

`locationkey` int,

`demandcostraw` float,

`scpdemandbuildlatelimit` float,

`demandvcuftraw` float,

`spdemandqty` float,

`demandvcasesraw` float,

`demanddebugflag` float,

`demandquantityraw` float,

`demandwcasesraw` float,

`spdemandpriority` float,

`scpdemandbuildaheadlimit` float,

`demandretailraw` float,

`scpdemandincrementalflag` boolean,

`demandwcuftraw` float)

PARTITIONED BY (

`versionkey` int,

`timekey` date)

CLUSTERED BY (

itemkey)

INTO 100 BUCKETS

ROW FORMAT SERDE

'org.apache.hadoop.hive.ql.io.orc.OrcSerde'

STORED AS INPUTFORMAT

'org.apache.hadoop.hive.ql.io.orc.OrcInputFormat'

OUTPUTFORMAT

'org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat'

LOCATION

'hdfs://88888/warehouse/tablespace/managed/hive/schema_wmt1dept.db/demandpriority' |

TBLPROPERTIES (

'bucketing_version'='2',

'transactional'='true',

'transactional_properties'='default',

'transient_lastDdlTime'='1557938173')

Note : i have tried with MSCK REPAIR and ANALYZE commands but still no luck

[#2]

The above was originally posted in the Community Help Track. On Mon May 20 16:29 UTC 2019, a member of the HCC moderation staff moved it to the Data Processing track. The Community Help Track is intended for questions about using the HCC site itself.