[
https://issues.apache.org/jira/browse/DRILL-1965?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14273106#comment-14273106
]
Ramana Inukonda Nagaraj commented on DRILL-1965:
------------------------------------------------
Do we support interval types like P1D P1Y1M1DT1H1M etc. Is that valid?
I was checking [[email protected]] cases and found
{code}
0: jdbc:drill:> select cast(c_interval as varchar(100)) from `/user/root/data`;
+------------+
| EXPR$0 |
+------------+
| 00:01:00 |
| 05:00:00 |
| 10 days |
| 34 years |
| 3 mons |
| -00:00:14 |
| 1 day 02:03:04 |
| 6 years |
| 5 mons |
| 5 mons 12:00:00 |
| 01:00:00 |
| 02:00:00 |
| -08:00:00 |
| -1 days +02:03:00 |
| -1 days +02:03:00 |
| 10 days 12:00:00 |
| 1 mon 15 days |
| 9 years 1 mon -12 days +13:14:00 |
| 3 years 5 mons 12 days 360:00:00 |
| -3 years -5 mons -12 days +360:00:00 |
| -12 days |
| 9 mons -27 days +12:34:56 |
| -3 years +482 days 76:54:32.189 |
+------------+
{code}
as sources for cast to interval year, day etc. Maybe [~mehant] could shed more
light.
> Expand read and write testing for parquet across all supported types
> --------------------------------------------------------------------
>
> Key: DRILL-1965
> URL: https://issues.apache.org/jira/browse/DRILL-1965
> Project: Apache Drill
> Issue Type: Bug
> Reporter: Jason Altekruse
> Assignee: Ramana Inukonda Nagaraj
> Attachments: DRILL-1965-WIP-parquet-file-all-types.patch
>
>
> The additional types we added to the parquet spec to allow use of parquet as
> a general purpose export format for drill query results have not all been
> thoroughly tested, we should make a better set of tests to ensure that the
> read and write path for the types are all working properly.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
