[ 
https://issues.apache.org/jira/browse/IMPALA-3451?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18083938#comment-18083938
 ] 

ASF subversion and git services commented on IMPALA-3451:
---------------------------------------------------------

Commit 443bec5f8996bca32833c253878c6474ad9e7d7c in impala's branch 
refs/heads/master from Pranav Lodha
[ https://gitbox.apache.org/repos/asf?p=impala.git;h=443bec5f8 ]

IMPALA-3451: Update the maximum length of comments

This patch updates the maximum length of a comment which
is controlled by CREATE_MAX_COMMENT_LENGTH to 4000. The patch
also readjusts some tests with the new comment length.

The reference patch in hive for the comment limit adjustment is
HIVE-21337(https://github.com/apache/hive/commit/8ab6ced1129).

Testing: Tests updated in AnalyzeDDLTest.java and added some
HMS interaction tests.

Change-Id: Ib49dd40ddf1c280c4be9728e096d9cf039c7def2
Reviewed-on: http://gerrit.cloudera.org:8080/24300
Reviewed-by: Impala Public Jenkins <[email protected]>
Tested-by: Impala Public Jenkins <[email protected]>


> Long comments should not break queries
> --------------------------------------
>
>                 Key: IMPALA-3451
>                 URL: https://issues.apache.org/jira/browse/IMPALA-3451
>             Project: IMPALA
>          Issue Type: Bug
>          Components: Catalog
>    Affects Versions: Impala 2.3.0
>            Reporter: Marcell Szabo
>            Assignee: Pranav Yogi Lodha
>            Priority: Critical
>              Labels: ramp-up, usability
>             Fix For: Impala 5.0.0
>
>
> 1) The type of column "COMMENT" in HMS DB table "COLUMNS_V2" is varchar(256), 
> which makes Impala thinks the max length of comment is just 256 characters 
> 2) A table defined with an avro schema file can have a comment that is longer 
> than 256 characters.
> Querying from such table causes:
> ERROR: AnalysisException: Failed to load metadata for table: 'database.table' 
> CAUSED BY: TableLoadingException: Failed to load metadata for table: 
> database.table 
> CAUSED BY: AnalysisException: Comment of column 'columnname' exceeds maximum 
> length of 256 characters: 
> <comment>. has 267 characters. 
> Impala should ignore / truncate the comment and execute the query normally.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to