You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "Jaden Perleoni (Jira)" <ji...@apache.org> on 2022/04/23 18:47:00 UTC

[jira] (IMPALA-11215) Impala shows invalid warning about row formats when TEXTFILE or SEQUENCEFILE is used

    [ https://issues.apache.org/jira/browse/IMPALA-11215 ]


    Jaden Perleoni deleted comment on IMPALA-11215:
    -----------------------------------------

was (Author: JIRAUSER288524):
Can I be assigned this issue?

> Impala shows invalid warning about row formats when TEXTFILE or SEQUENCEFILE is used
> ------------------------------------------------------------------------------------
>
>                 Key: IMPALA-11215
>                 URL: https://issues.apache.org/jira/browse/IMPALA-11215
>             Project: IMPALA
>          Issue Type: Bug
>          Components: Frontend
>            Reporter: Zoltán Borók-Nagy
>            Priority: Major
>              Labels: newbie, ramp-up
>
> Reproduce:
>  
> {noformat}
> [localhost:21050] default> create table delim(i int) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' stored as textfile;
> Query: create table delim(i int) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' stored as textfile
> +-------------------------+
> | summary                 |
> +-------------------------+
> | Table has been created. |
> +-------------------------+
> WARNINGS: 'ROW FORMAT DELIMITED FIELDS TERMINATED BY ','' is ignored.
> Fetched 1 row(s) in 153.82s
> {noformat}
> The WARNING is invalid since the row format is not ignored for text files.
> The problem is coming from this line:
> [https://github.com/apache/impala/blob/38062b4ec0cfdf28474c84d136718510fe712437/fe/src/main/java/org/apache/impala/analysis/CreateTableStmt.java#L276]
> The following condition will be always true:
> {noformat}
>       if (getFileFormat() != THdfsFileFormat.TEXT
>           || getFileFormat() != THdfsFileFormat.SEQUENCE_FILE)
> {noformat}
>  Instead of || we need to use &&.



--
This message was sent by Atlassian Jira
(v8.20.7#820007)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org