Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Hive table showing the count and not displaying the data

Highlighted

Hive table showing the count and not displaying the data

Super Collaborator

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

1 REPLY 1

Re: Hive table showing the count and not displaying the data

Community Manager

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.