[jira] [Commented] (DRILL-5018) Metadata cache has duplicate columnTypeInfo values

["Robert Hou (JIRA)" <ji...@apache.org>]

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

Robert Hou commented on DRILL-5018:
-----------------------------------

For the second lineitem table, use CTAS with the first lineitem table.

   create table lineitem2 as select * from lineitem;

> Metadata cache has duplicate columnTypeInfo values
> --------------------------------------------------
>
>                 Key: DRILL-5018
>                 URL: https://issues.apache.org/jira/browse/DRILL-5018
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Metadata
>    Affects Versions: 1.8.0
>            Reporter: Robert Hou
>            Assignee: Parth Chandra
>         Attachments: lineitem_1_0_1.parquet, lineitem_999.parquet
>
>
> This lineitem table has duplicate entries in its metadata file, although the entries have slightly different values.  This lineitem table uses directory-based partitioning on year and month.
>   "columnTypeInfo" : {
>     "L_RETURNFLAG" : {
>       "name" : [ "L_RETURNFLAG" ],
>       "primitiveType" : "BINARY",
>       "originalType" : null,
>       "precision" : 0,
>       "scale" : 0,
>       "repetitionLevel" : 0,
>       "definitionLevel" : 1
>     },
>     "l_returnflag" : {
>       "name" : [ "l_returnflag" ],
>       "primitiveType" : "BINARY",
>       "originalType" : "UTF8",
>       "precision" : 0,
>       "scale" : 0,
>       "repetitionLevel" : 0,
>       "definitionLevel" : 0
>     },
> This lineitem table has two entries in its metadata file for each column, but the two entries have different column names (adding a zero).  It also has slightly different values.  This lineitem table was created using CTAS with the first table above.
>     "l_shipinstruct" : {
>       "name" : [ "l_shipinstruct" ],
>       "primitiveType" : "BINARY",
>       "originalType" : "UTF8",
>       "precision" : 0,
>       "scale" : 0,
>       "repetitionLevel" : 0,
>       "definitionLevel" : 0
>     },
>     "L_SHIPINSTRUCT0" : {
>       "name" : [ "L_SHIPINSTRUCT0" ],
>       "primitiveType" : "BINARY",
>       "originalType" : null,
>       "precision" : 0,
>       "scale" : 0,
>       "repetitionLevel" : 0,
>       "definitionLevel" : 1
>     },



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)