[
https://issues.apache.org/jira/browse/DRILL-2660?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Daniel Barclay (Drill) updated DRILL-2660:
------------------------------------------
Description:
I don't know if data type name "MULTISET" is intended to be supported or not,
but trying to use it in a CAST specification yields an internal error message
"use createMultisetType() instead":
0: jdbc:drill:zk=local> CREATE OR REPLACE VIEW TempView AS SELECT CAST(columns
AS MULTISET), columns FROM `dfs.tmp`.`dsbtemp/TempCsv`;
Query failed: AssertionError: use createMultisetType() instead
Error: exception while executing query: Failure while executing query.
(state=,code=0)
0: jdbc:drill:zk=local>
The directory corresponding to `dfs.tmp`.`dsbtemp/TempCsv` contained the two
attached CSV files.
was:
I don't know if data type name "MAP" is intended to be supported or not, but
trying to use it in a CAST specification yields an internal error message "use
createMultisetType() instead":
0: jdbc:drill:zk=local> CREATE OR REPLACE VIEW TempView AS SELECT CAST(columns
AS MULTISET), columns FROM `dfs.tmp`.`dsbtemp/TempCsv`;
Query failed: AssertionError: use createMultisetType() instead
Error: exception while executing query: Failure while executing query.
(state=,code=0)
0: jdbc:drill:zk=local>
The directory corresponding to `dfs.tmp`.`dsbtemp/TempCsv` contained the two
attached CSV files.
> CAST to MULTISET yields internal "use createMultisetType() instead" error
> -------------------------------------------------------------------------
>
> Key: DRILL-2660
> URL: https://issues.apache.org/jira/browse/DRILL-2660
> Project: Apache Drill
> Issue Type: Bug
> Reporter: Daniel Barclay (Drill)
> Attachments: Temp1.csv, Temp2.csv
>
>
> I don't know if data type name "MULTISET" is intended to be supported or not,
> but trying to use it in a CAST specification yields an internal error message
> "use createMultisetType() instead":
> 0: jdbc:drill:zk=local> CREATE OR REPLACE VIEW TempView AS SELECT
> CAST(columns AS MULTISET), columns FROM `dfs.tmp`.`dsbtemp/TempCsv`;
> Query failed: AssertionError: use createMultisetType() instead
> Error: exception while executing query: Failure while executing query.
> (state=,code=0)
> 0: jdbc:drill:zk=local>
> The directory corresponding to `dfs.tmp`.`dsbtemp/TempCsv` contained the two
> attached CSV files.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
