[jira] [Updated] (HIVE-21951) Llap query on external table with header or footer returns incorrect row count.

2019-07-03 Thread Sankar Hariappan (JIRA) 


 [ 
https://issues.apache.org/jira/browse/HIVE-21951?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Sankar Hariappan updated HIVE-21951:

Status: Patch Available  (was: Open)

> Llap query on external table with header or footer returns incorrect row 
> count.
> ---
>
> Key: HIVE-21951
> URL: https://issues.apache.org/jira/browse/HIVE-21951
> Project: Hive
>  Issue Type: Bug
>  Components: llap, Query Processor
>Affects Versions: 2.4.0, 4.0.0
>Reporter: Sankar Hariappan
>Assignee: Sankar Hariappan
>Priority: Major
> Attachments: HIVE-21951.01.patch
>
>
> If create a table with header and footer as follows.
> {code}
> CREATE EXTERNAL TABLE IF NOT EXISTS externaltableOpenCSV (eid int, name 
> String, salary String, destination String)
>  COMMENT 'Employee details'
>  ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.OpenCSVSerde'
>  STORED AS TEXTFILE
>  LOCATION '/externaltableOpenCSV'
>  tblproperties ("skip.header.line.count"="1", "skip.footer.line.count"="2");
> {code}
> Now, query on this table returns incorrect row count as header/footer are not 
> skipped.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Updated] (HIVE-21951) Llap query on external table with header or footer returns incorrect row count.

2019-07-03 Thread Sankar Hariappan (JIRA) 


 [ 
https://issues.apache.org/jira/browse/HIVE-21951?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Sankar Hariappan updated HIVE-21951:

Attachment: HIVE-21951.01.patch

> Llap query on external table with header or footer returns incorrect row 
> count.
> ---
>
> Key: HIVE-21951
> URL: https://issues.apache.org/jira/browse/HIVE-21951
> Project: Hive
>  Issue Type: Bug
>  Components: llap, Query Processor
>Affects Versions: 2.4.0, 4.0.0
>Reporter: Sankar Hariappan
>Assignee: Sankar Hariappan
>Priority: Major
> Attachments: HIVE-21951.01.patch
>
>
> If create a table with header and footer as follows.
> {code}
> CREATE EXTERNAL TABLE IF NOT EXISTS externaltableOpenCSV (eid int, name 
> String, salary String, destination String)
>  COMMENT 'Employee details'
>  ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.OpenCSVSerde'
>  STORED AS TEXTFILE
>  LOCATION '/externaltableOpenCSV'
>  tblproperties ("skip.header.line.count"="1", "skip.footer.line.count"="2");
> {code}
> Now, query on this table returns incorrect row count as header/footer are not 
> skipped.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Updated] (HIVE-21951) Llap query on external table with header or footer returns incorrect row count.

2019-07-03 Thread Sankar Hariappan (JIRA) 


 [ 
https://issues.apache.org/jira/browse/HIVE-21951?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Sankar Hariappan updated HIVE-21951:

Affects Version/s: 3.2.0

> Llap query on external table with header or footer returns incorrect row 
> count.
> ---
>
> Key: HIVE-21951
> URL: https://issues.apache.org/jira/browse/HIVE-21951
> Project: Hive
>  Issue Type: Bug
>  Components: llap, Query Processor
>Affects Versions: 2.4.0, 4.0.0, 3.2.0
>Reporter: Sankar Hariappan
>Assignee: Sankar Hariappan
>Priority: Major
> Attachments: HIVE-21951.01.patch
>
>
> If create a table with header and footer as follows.
> {code}
> CREATE EXTERNAL TABLE IF NOT EXISTS externaltableOpenCSV (eid int, name 
> String, salary String, destination String)
>  COMMENT 'Employee details'
>  ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.OpenCSVSerde'
>  STORED AS TEXTFILE
>  LOCATION '/externaltableOpenCSV'
>  tblproperties ("skip.header.line.count"="1", "skip.footer.line.count"="2");
> {code}
> Now, query on this table returns incorrect row count as header/footer are not 
> skipped.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Updated] (HIVE-21951) Llap query on external table with header or footer returns incorrect row count.

2019-07-03 Thread Sankar Hariappan (JIRA) 


 [ 
https://issues.apache.org/jira/browse/HIVE-21951?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Sankar Hariappan updated HIVE-21951:

Description: 
Create a table with header and footer as follows.
{code}
CREATE EXTERNAL TABLE IF NOT EXISTS externaltableOpenCSV (eid int, name String, 
salary String, destination String)
 COMMENT 'Employee details'
 ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.OpenCSVSerde'
 STORED AS TEXTFILE
 LOCATION '/externaltableOpenCSV'
 tblproperties ("skip.header.line.count"="1", "skip.footer.line.count"="2");
{code}

Now, query on this table returns incorrect row count as header/footer are not 
skipped.


  was:
If create a table with header and footer as follows.
{code}
CREATE EXTERNAL TABLE IF NOT EXISTS externaltableOpenCSV (eid int, name String, 
salary String, destination String)
 COMMENT 'Employee details'
 ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.OpenCSVSerde'
 STORED AS TEXTFILE
 LOCATION '/externaltableOpenCSV'
 tblproperties ("skip.header.line.count"="1", "skip.footer.line.count"="2");
{code}

Now, query on this table returns incorrect row count as header/footer are not 
skipped.



> Llap query on external table with header or footer returns incorrect row 
> count.
> ---
>
> Key: HIVE-21951
> URL: https://issues.apache.org/jira/browse/HIVE-21951
> Project: Hive
>  Issue Type: Bug
>  Components: llap, Query Processor
>Affects Versions: 2.4.0, 4.0.0, 3.2.0
>Reporter: Sankar Hariappan
>Assignee: Sankar Hariappan
>Priority: Major
> Attachments: HIVE-21951.01.patch
>
>
> Create a table with header and footer as follows.
> {code}
> CREATE EXTERNAL TABLE IF NOT EXISTS externaltableOpenCSV (eid int, name 
> String, salary String, destination String)
>  COMMENT 'Employee details'
>  ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.OpenCSVSerde'
>  STORED AS TEXTFILE
>  LOCATION '/externaltableOpenCSV'
>  tblproperties ("skip.header.line.count"="1", "skip.footer.line.count"="2");
> {code}
> Now, query on this table returns incorrect row count as header/footer are not 
> skipped.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Updated] (HIVE-21951) Llap query on external table with header or footer returns incorrect row count.

2019-07-03 Thread Sankar Hariappan (JIRA) 


 [ 
https://issues.apache.org/jira/browse/HIVE-21951?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Sankar Hariappan updated HIVE-21951:

Target Version/s: 4.0.0, 3.2.0  (was: 4.0.0)

> Llap query on external table with header or footer returns incorrect row 
> count.
> ---
>
> Key: HIVE-21951
> URL: https://issues.apache.org/jira/browse/HIVE-21951
> Project: Hive
>  Issue Type: Bug
>  Components: llap, Query Processor
>Affects Versions: 2.4.0, 4.0.0, 3.2.0
>Reporter: Sankar Hariappan
>Assignee: Sankar Hariappan
>Priority: Major
> Attachments: HIVE-21951.01.patch
>
>
> Create a table with header and footer as follows.
> {code}
> CREATE EXTERNAL TABLE IF NOT EXISTS externaltableOpenCSV (eid int, name 
> String, salary String, destination String)
>  COMMENT 'Employee details'
>  ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.OpenCSVSerde'
>  STORED AS TEXTFILE
>  LOCATION '/externaltableOpenCSV'
>  tblproperties ("skip.header.line.count"="1", "skip.footer.line.count"="2");
> {code}
> Now, query on this table returns incorrect row count as header/footer are not 
> skipped.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Updated] (HIVE-21951) Llap query on external table with header or footer returns incorrect row count.

2019-07-04 Thread Sankar Hariappan (JIRA) 


 [ 
https://issues.apache.org/jira/browse/HIVE-21951?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Sankar Hariappan updated HIVE-21951:

Attachment: HIVE-21951.02.patch

> Llap query on external table with header or footer returns incorrect row 
> count.
> ---
>
> Key: HIVE-21951
> URL: https://issues.apache.org/jira/browse/HIVE-21951
> Project: Hive
>  Issue Type: Bug
>  Components: llap, Query Processor
>Affects Versions: 2.4.0, 4.0.0, 3.2.0
>Reporter: Sankar Hariappan
>Assignee: Sankar Hariappan
>Priority: Major
> Attachments: HIVE-21951.01.patch, HIVE-21951.02.patch
>
>
> Create a table with header and footer as follows.
> {code}
> CREATE EXTERNAL TABLE IF NOT EXISTS externaltableOpenCSV (eid int, name 
> String, salary String, destination String)
>  COMMENT 'Employee details'
>  ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.OpenCSVSerde'
>  STORED AS TEXTFILE
>  LOCATION '/externaltableOpenCSV'
>  tblproperties ("skip.header.line.count"="1", "skip.footer.line.count"="2");
> {code}
> Now, query on this table returns incorrect row count as header/footer are not 
> skipped.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Updated] (HIVE-21951) Llap query on external table with header or footer returns incorrect row count.

2019-07-04 Thread Sankar Hariappan (JIRA) 


 [ 
https://issues.apache.org/jira/browse/HIVE-21951?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Sankar Hariappan updated HIVE-21951:

Status: Open  (was: Patch Available)

> Llap query on external table with header or footer returns incorrect row 
> count.
> ---
>
> Key: HIVE-21951
> URL: https://issues.apache.org/jira/browse/HIVE-21951
> Project: Hive
>  Issue Type: Bug
>  Components: llap, Query Processor
>Affects Versions: 2.4.0, 4.0.0, 3.2.0
>Reporter: Sankar Hariappan
>Assignee: Sankar Hariappan
>Priority: Major
> Attachments: HIVE-21951.01.patch, HIVE-21951.02.patch
>
>
> Create a table with header and footer as follows.
> {code}
> CREATE EXTERNAL TABLE IF NOT EXISTS externaltableOpenCSV (eid int, name 
> String, salary String, destination String)
>  COMMENT 'Employee details'
>  ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.OpenCSVSerde'
>  STORED AS TEXTFILE
>  LOCATION '/externaltableOpenCSV'
>  tblproperties ("skip.header.line.count"="1", "skip.footer.line.count"="2");
> {code}
> Now, query on this table returns incorrect row count as header/footer are not 
> skipped.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Updated] (HIVE-21951) Llap query on external table with header or footer returns incorrect row count.

2019-07-04 Thread Sankar Hariappan (JIRA) 


 [ 
https://issues.apache.org/jira/browse/HIVE-21951?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Sankar Hariappan updated HIVE-21951:

Status: Patch Available  (was: Open)

> Llap query on external table with header or footer returns incorrect row 
> count.
> ---
>
> Key: HIVE-21951
> URL: https://issues.apache.org/jira/browse/HIVE-21951
> Project: Hive
>  Issue Type: Bug
>  Components: llap, Query Processor
>Affects Versions: 2.4.0, 4.0.0, 3.2.0
>Reporter: Sankar Hariappan
>Assignee: Sankar Hariappan
>Priority: Major
> Attachments: HIVE-21951.01.patch, HIVE-21951.02.patch
>
>
> Create a table with header and footer as follows.
> {code}
> CREATE EXTERNAL TABLE IF NOT EXISTS externaltableOpenCSV (eid int, name 
> String, salary String, destination String)
>  COMMENT 'Employee details'
>  ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.OpenCSVSerde'
>  STORED AS TEXTFILE
>  LOCATION '/externaltableOpenCSV'
>  tblproperties ("skip.header.line.count"="1", "skip.footer.line.count"="2");
> {code}
> Now, query on this table returns incorrect row count as header/footer are not 
> skipped.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Updated] (HIVE-21951) Llap query on external table with header or footer returns incorrect row count.

2019-07-08 Thread Sankar Hariappan (JIRA) 


 [ 
https://issues.apache.org/jira/browse/HIVE-21951?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Sankar Hariappan updated HIVE-21951:

Status: Open  (was: Patch Available)

> Llap query on external table with header or footer returns incorrect row 
> count.
> ---
>
> Key: HIVE-21951
> URL: https://issues.apache.org/jira/browse/HIVE-21951
> Project: Hive
>  Issue Type: Bug
>  Components: llap, Query Processor
>Affects Versions: 2.4.0, 4.0.0, 3.2.0
>Reporter: Sankar Hariappan
>Assignee: Sankar Hariappan
>Priority: Major
> Attachments: HIVE-21951.01.patch, HIVE-21951.02.patch
>
>
> Create a table with header and footer as follows.
> {code}
> CREATE EXTERNAL TABLE IF NOT EXISTS externaltableOpenCSV (eid int, name 
> String, salary String, destination String)
>  COMMENT 'Employee details'
>  ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.OpenCSVSerde'
>  STORED AS TEXTFILE
>  LOCATION '/externaltableOpenCSV'
>  tblproperties ("skip.header.line.count"="1", "skip.footer.line.count"="2");
> {code}
> Now, query on this table returns incorrect row count as header/footer are not 
> skipped.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)