hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Zoltan Haindrich (JIRA)" <>
Subject [jira] [Commented] (HIVE-19943) Header values keep showing up in result sets
Date Tue, 26 Jun 2018 06:31:00 GMT


Zoltan Haindrich commented on HIVE-19943:

I think it should probably work the same way there as the regular hive :D
I've a hunch that probably the stats optimizer have got the wrong value; and on hdi that thing
is turned on...
Could you please upload the textfile with the appropriate contents; and give the commands
being used - to be sure that we are on the same page here?

> Header values keep showing up in result sets
> --------------------------------------------
>                 Key: HIVE-19943
>                 URL:
>             Project: Hive
>          Issue Type: Bug
>          Components: Query Processor
>    Affects Versions: 2.1.0
>         Environment: Hdinsight Hive interactivequerry
> [Components|]
>            Reporter: Liam De Lee
>            Priority: Major
> We are using the tblproperties ("skip.header.line.count"="1") when creating an external
> When we do a select * from table we get it back as expected without the header present
in the result set.
> However when we do for instance a count(1) we get the header back in this count (tested
with a select * from table and paste it in notepad to find the amount of rows)
> If we also do this with a select distinct(column) from table we also get the header as
a distinct value.
> file structure:
> |adf|
> |hyg|
> |abc|

This message was sent by Atlassian JIRA

View raw message