[
https://issues.apache.org/jira/browse/DRILL-4019?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14987676#comment-14987676
]
Jacques Nadeau commented on DRILL-4019:
---
You marked this as 1.2. Is that mean this is from the 1.2 release? I want to
confirm this isn't a new regression with last night's merges.
> Limit 0 with two flatten operators in a query fails with unsupported exception
> --
>
> Key: DRILL-4019
> URL: https://issues.apache.org/jira/browse/DRILL-4019
> Project: Apache Drill
> Issue Type: Bug
> Components: Execution - Relational Operators
>Affects Versions: 1.2.0
>Reporter: Victoria Markman
>
> I think this is manifestation of DRILL-2256 in a different SQL scenario.
> test.json
> {code}
> {
> "c1" : [[1,2,3],[10,20,30]]
> }
> {code}
> Two flatten operators with limit zero fails:
> {code}
> 0: jdbc:drill:schema=dfs> select flatten(c1[0]), flatten(c1[1]) from
> `test.json` limit 0;
> Error: SYSTEM ERROR: UnsupportedOperationException: Unable to get value
> vector class for minor type [LATE] and mode [OPTIONAL]
> Fragment 0:0
> [Error Id: 0f19b566-ca53-43c7-ae0f-fec39c909cfd on atsqa4-133.qa.lab:31010]
> (state=,code=0)
> {code}
> Single flatten: works
> {code}
> 0: jdbc:drill:schema=dfs> select flatten(c1[0]) from `test.json` limit 0;
> +-+
> | EXPR$0 |
> +-+
> +-+
> No rows selected (0.258 seconds)
> {code}
> Without limit 0:
> {code}
> 0: jdbc:drill:schema=dfs> select flatten(c1[0]) from `test.json`;
> +-+
> | EXPR$0 |
> +-+
> | 1 |
> | 2 |
> | 3 |
> +-+
> 3 rows selected (0.268 seconds)
> 0: jdbc:drill:schema=dfs> select flatten(c1[0]), flatten(c1[1]) from
> `test.json`;
> +-+-+
> | EXPR$0 | EXPR$1 |
> +-+-+
> | 1 | 10 |
> | 1 | 20 |
> | 1 | 30 |
> | 2 | 10 |
> | 2 | 20 |
> | 2 | 30 |
> | 3 | 10 |
> | 3 | 20 |
> | 3 | 30 |
> +-+-+
> 9 rows selected (0.26 seconds)
> {code}
> drillbit.log
> {code}
> 2015-11-03 17:13:19,237 [29c714cf-fdc7-2ac9-5fd4-c4fdae636550:foreman] INFO
> o.a.d.e.s.schedule.BlockMapBuilder - Failure finding Drillbit running on host
> atsqa4-135.qa.lab. Skipping affinity to that host.
> 2015-11-03 17:13:19,237 [29c714cf-fdc7-2ac9-5fd4-c4fdae636550:foreman] INFO
> o.a.d.e.s.schedule.BlockMapBuilder - Failure finding Drillbit running on host
> atsqa4-134.qa.lab. Skipping affinity to that host.
> 2015-11-03 17:13:19,237 [29c714cf-fdc7-2ac9-5fd4-c4fdae636550:foreman] INFO
> o.a.d.e.s.schedule.BlockMapBuilder - Get block maps: Executed 1 out of 1
> using 1 threads. Time: 1ms total, 1.717980ms avg, 1ms max.
> 2015-11-03 17:13:19,237 [29c714cf-fdc7-2ac9-5fd4-c4fdae636550:foreman] INFO
> o.a.d.e.s.schedule.BlockMapBuilder - Get block maps: Executed 1 out of 1
> using 1 threads. Earliest start: 1.82 μs, Latest start: 1.82 μs,
> Average start: 1.82 μs .
> 2015-11-03 17:13:19,263 [29c714cf-fdc7-2ac9-5fd4-c4fdae636550:frag:0:0] INFO
> o.a.d.e.w.fragment.FragmentExecutor -
> 29c714cf-fdc7-2ac9-5fd4-c4fdae636550:0:0: State change requested
> AWAITING_ALLOCATION --> RUNNING
> 2015-11-03 17:13:19,263 [29c714cf-fdc7-2ac9-5fd4-c4fdae636550:frag:0:0] INFO
> o.a.d.e.w.f.FragmentStatusReporter -
> 29c714cf-fdc7-2ac9-5fd4-c4fdae636550:0:0: State to report: RUNNING
> 2015-11-03 17:13:19,269 [29c714cf-fdc7-2ac9-5fd4-c4fdae636550:frag:0:0] INFO
> o.a.d.e.w.fragment.FragmentExecutor -
> 29c714cf-fdc7-2ac9-5fd4-c4fdae636550:0:0: State change requested RUNNING -->
> FAILED
> 2015-11-03 17:13:19,269 [29c714cf-fdc7-2ac9-5fd4-c4fdae636550:frag:0:0] INFO
> o.a.d.e.w.fragment.FragmentExecutor -
> 29c714cf-fdc7-2ac9-5fd4-c4fdae636550:0:0: State change requested FAILED -->
> FINISHED
> 2015-11-03 17:13:19,271 [29c714cf-fdc7-2ac9-5fd4-c4fdae636550:frag:0:0] ERROR
> o.a.d.e.w.fragment.FragmentExecutor - SYSTEM ERROR:
> UnsupportedOperationException: Unable to get value vector class for minor
> type [LATE] and mode [OPTIONAL]
> Fragment 0:0
> [Error Id: 95cd27b5-065d-4714-a3e0-cd8d8ff6d519 on atsqa4-133.qa.lab:31010]
> org.apache.drill.common.exceptions.UserException: SYSTEM ERROR:
> UnsupportedOperationException: Unable to get value vector class for minor
> type [LATE] and mode [OPTIONAL]
> Fragment 0:0
> [Error Id: 95cd27b5-065d-4714-a3e0-cd8d8ff6d519 on atsqa4-133.qa.lab:31010]
> at
> org.apache.drill.common.exceptions.UserException$Builder.build(UserException.java:534)
> ~[drill-common-1.2.0.jar:1.2.0]
> at
> org.apache.drill.exec.work.fragment.FragmentExecutor.sendFinalState(FragmentExecutor.java:323)
> [drill-java-exec-1.2.0.jar:1.2.0]
> at
> org.apache.drill.exec.work.fragme
