[
https://issues.apache.org/jira/browse/DRILL-5326?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15900411#comment-15900411
]
Vitalii Diravka commented on DRILL-5326:
----------------------------------------
Example of the row order sorting with nulls:
{code}
0: jdbc:drill:zk=local> select a from
dfs.`/home/vitalii/IdeaProjects/drill/exec/java-exec/src/test/resources/parquet/data.snappy.parquet`
limit 5;
+--------+
| a |
+--------+
| null |
| null |
| 67985 |
| null |
| null |
+--------+
5 rows selected (0.153 seconds)
0: jdbc:drill:zk=local> select a from
dfs.`/home/vitalii/IdeaProjects/drill/exec/java-exec/src/test/resources/parquet/data.snappy.parquet`
order by `a` limit 5;
+------+
| a |
+------+
| 42 |
| 50 |
| 95 |
| 116 |
| 116 |
+------+
5 rows selected (0.248 seconds)
0: jdbc:drill:zk=local> select a from
dfs.`/home/vitalii/IdeaProjects/drill/exec/java-exec/src/test/resources/parquet/data.snappy.parquet`
order by `a` DESC limit 5;
+-------+
| a |
+-------+
| null |
| null |
| null |
| null |
| null |
+-------+
5 rows selected (0.247 seconds)
{code}
> Unit tests failures related to the SERVER_METADTA
> -------------------------------------------------
>
> Key: DRILL-5326
> URL: https://issues.apache.org/jira/browse/DRILL-5326
> Project: Apache Drill
> Issue Type: Bug
> Components: Metadata
> Affects Versions: 1.10.0
> Reporter: Vitalii Diravka
> Assignee: Vitalii Diravka
> Priority: Blocker
> Fix For: 1.10.0
>
>
> 1. In DRILL-5301 a new SERVER_META rpc call was introduced. The server will
> support this method only from 1.10.0 drill version. For drill 1.10.0-SNAPHOT
> it is disabled.
> When I enabled this method (by way of upgrading drill version to 1.10.0 or
> 1.11.0-SNAPSHOT) I found the following exception:
> {code}
> java.lang.AssertionError: Unexpected/unhandled MinorType value GENERIC_OBJECT
> {code}
> It appears in several tests (for example in
> DatabaseMetadataTest#testNullsAreSortedMethodsSaySortedHigh).
> The reason of it is "GENERIC_OBJECT" RPC-/protobuf-level type is appeared in
> the ServerMetadata#ConvertSupportList. (Supporting of GENERIC_OBJECT was
> added in DRILL-1126).
> The proposed solution is to add the appropriate "JAVA_OBJECT" sql type name
> for this "GENERIC_OBJECT" RPC-/protobuf-level data type.
> 2. After fixing the first one the mentioned above test still fails by reason
> of the incorrect "NullCollation" value in the "ServerMetaProvider". According
> to the [doc|https://drill.apache.org/docs/order-by-clause/#usage-notes] the
> default val should be NC_HIGH (NULL is the highest value).
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
