[
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)
