You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@hive.apache.org by "Shawn Weeks (JIRA)" <ji...@apache.org> on 2019/04/01 18:11:00 UTC

[jira] [Commented] (HIVE-21560) Update Derby DDL to use CLOB instead of LONG VARCHAR

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

Shawn Weeks commented on HIVE-21560:
------------------------------------

I tested this and changing the two columns to clob didn’t seem to break anything. I was able to create views more 32kb and queries against them didn’t fail. 

> Update Derby DDL to use CLOB instead of LONG VARCHAR
> ----------------------------------------------------
>
>                 Key: HIVE-21560
>                 URL: https://issues.apache.org/jira/browse/HIVE-21560
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Shawn Weeks
>            Assignee: Rajkumar Singh
>            Priority: Minor
>
> in the Hive 1.x and 2.x metastore version for Derby there are two column in "TBLS" that are set to LONG VARCHAR. This causes larger create view statements to fail when using embedded metastore for testing.



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