Created 05-16-2019 08:01 AM
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
Created 05-20-2019 04:30 PM
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.