drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Victoria Markman (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-2041) Throw unsupported error message on GROUP BY/ORDER BY array/map types
Date Tue, 20 Jan 2015 00:27:35 GMT
Victoria Markman created DRILL-2041:
---------------------------------------

             Summary: Throw unsupported error message on GROUP BY/ORDER BY array/map types
                 Key: DRILL-2041
                 URL: https://issues.apache.org/jira/browse/DRILL-2041
             Project: Apache Drill
          Issue Type: Bug
          Components: Query Planning & Optimization
    Affects Versions: 0.8.0
            Reporter: Victoria Markman
            Assignee: Jinfeng Ni


test.json
{code}
{ "CustomerId": "100", "cityId": 10 , "phoneNumber": { "areaCode": "622", "number": "1567845"},
"years": ["1990", "1993", "1998", "2008"]}{code}

{code}
0: jdbc:drill:schema=dfs> select years from `test.json` order by years;
+------------+
|   years    |
+------------+
Query failed: RemoteRpcException: Failure while running fragment., Failure finding function
that runtime code generation expected.  Signature: compare_to( VARCHAR:REPEATEDVARCHAR:REPEATED,
 ) returns INT:REQUIRED [ 5e4a9574-1f9b-4753-ab1d-ef056639281f on atsqa4-133.qa.lab:31010
]
[ 5e4a9574-1f9b-4753-ab1d-ef056639281f on atsqa4-133.qa.lab:31010 ]
java.lang.RuntimeException: java.sql.SQLException: Failure while executing query.
	at sqlline.SqlLine$IncrementalRows.hasNext(SqlLine.java:2514)
	at sqlline.SqlLine$TableOutputFormat.print(SqlLine.java:2148)
	at sqlline.SqlLine.print(SqlLine.java:1809)
	at sqlline.SqlLine$Commands.execute(SqlLine.java:3766)
	at sqlline.SqlLine$Commands.sql(SqlLine.java:3663)
	at sqlline.SqlLine.dispatch(SqlLine.java:889)
	at sqlline.SqlLine.begin(SqlLine.java:763)
	at sqlline.SqlLine.start(SqlLine.java:498)
	at sqlline.SqlLine.main(SqlLine.java:460)

0: jdbc:drill:schema=dfs> select years from `test.json` group by years;
Query failed: RemoteRpcException: Failure while running fragment., Failure finding function
that runtime code generation expected.  Signature: compare_to( VARCHAR:REPEATEDVARCHAR:REPEATED,
 ) returns INT:REQUIRED [ be1d64d5-bb03-4d5d-87b0-5cd8aa32f007 on atsqa4-133.qa.lab:31010
]
[ be1d64d5-bb03-4d5d-87b0-5cd8aa32f007 on atsqa4-133.qa.lab:31010 ]
Error: exception while executing query: Failure while executing query. (state=,code=0)
{code}

{code}
0: jdbc:drill:schema=dfs> select * from `test.json` order by phoneNumber;
+------------+------------+-------------+------------+
| CustomerId |   cityId   | phoneNumber |   years    |
+------------+------------+-------------+------------+
Query failed: RemoteRpcException: Failure while running fragment., Failure finding function
that runtime code generation expected.  Signature: compare_to( MAP:REQUIREDMAP:REQUIRED, 
) returns INT:REQUIRED [ cbef0629-b393-4fbd-9c16-941ec8835d36 on atsqa4-133.qa.lab:31010 ]
[ cbef0629-b393-4fbd-9c16-941ec8835d36 on atsqa4-133.qa.lab:31010 ]
java.lang.RuntimeException: java.sql.SQLException: Failure while executing query.
	at sqlline.SqlLine$IncrementalRows.hasNext(SqlLine.java:2514)
	at sqlline.SqlLine$TableOutputFormat.print(SqlLine.java:2148)
	at sqlline.SqlLine.print(SqlLine.java:1809)
	at sqlline.SqlLine$Commands.execute(SqlLine.java:3766)
	at sqlline.SqlLine$Commands.sql(SqlLine.java:3663)
	at sqlline.SqlLine.dispatch(SqlLine.java:889)
	at sqlline.SqlLine.begin(SqlLine.java:763)
	at sqlline.SqlLine.start(SqlLine.java:498)
	at sqlline.SqlLine.main(SqlLine.java:460)

0: jdbc:drill:schema=dfs> select phoneNumber from `test.json` group by phoneNumber;
Query failed: RemoteRpcException: Failure while running fragment., Failure finding function
that runtime code generation expected.  Signature: compare_to( MAP:REQUIREDMAP:REQUIRED, 
) returns INT:REQUIRED [ fbd3ca20-5d5a-4831-a066-a2d780547e66 on atsqa4-133.qa.lab:31010 ]
[ fbd3ca20-5d5a-4831-a066-a2d780547e66 on atsqa4-133.qa.lab:31010 ]
Error: exception while executing query: Failure while executing query. (state=,code=0)

{code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message