[
https://issues.apache.org/jira/browse/HIVE-5795?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13859316#comment-13859316
]
Lefty Leverenz commented on HIVE-5795:
--------------------------------------
bq. How do I add the new parameters to the wikidoc?
Just add a release note to this ticket and I'll put the information in the
wikidoc after the patch gets committed. Or you could do it yourself, as long
as you remember to say it applies to version 0.13.0 and later.
* hive.file.max.footer goes in Configuration Properties in the [Query
Execution|https://cwiki.apache.org/confluence/display/Hive/Configuration+Properties#ConfigurationProperties-QueryExecution]
section
* skip.header.line.count & skip.footer.line.count need a new section somewhere,
most likely in the Create Table section of the
[DDL|https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL] doc
-- should there also be a link from the
[Select|https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Select]
doc or one of the SerDe docs
([HiveSerDe|https://cwiki.apache.org/confluence/display/Hive/DeveloperGuide#DeveloperGuide-HiveSerDe]
in the Developer Guide or
[SerDe|https://cwiki.apache.org/confluence/display/Hive/SerDe])?
> Hive should be able to skip header and footer rows when reading data file for
> a table
> -------------------------------------------------------------------------------------
>
> Key: HIVE-5795
> URL: https://issues.apache.org/jira/browse/HIVE-5795
> Project: Hive
> Issue Type: Bug
> Reporter: Shuaishuai Nie
> Assignee: Shuaishuai Nie
> Attachments: HIVE-5795.1.patch, HIVE-5795.2.patch, HIVE-5795.3.patch,
> HIVE-5795.4.patch
>
>
> Hive should be able to skip header and footer lines when reading data file
> from table. In this way, user don't need to processing data which generated
> by other application with a header or footer and directly use the file for
> table operations.
> To implement this, the idea is adding new properties in table descriptions to
> define the number of lines in header and footer and skip them when reading
> the record from record reader. An DDL example for creating a table with
> header and footer should be like this:
> {code}
> Create external table testtable (name string, message string) row format
> delimited fields terminated by '\t' lines terminated by '\n' location
> '/testtable' tblproperties ("skip.header.line.count"="1",
> "skip.footer.line.count"="2");
> {code}
--
This message was sent by Atlassian JIRA
(v6.1.5#6160)
