[jira] [Created] (DRILL-2112) Throw helpful error message with unsupported KVGen functionality

["Neeraja (JIRA)" <ji...@apache.org>]

Neeraja created DRILL-2112:
------------------------------

             Summary: Throw helpful error message with unsupported KVGen functionality 
                 Key: DRILL-2112
                 URL: https://issues.apache.org/jira/browse/DRILL-2112
             Project: Apache Drill
          Issue Type: Bug
            Reporter: Neeraja
             Fix For: 0.9.0


KVGen function currently doesn't support maps with changing data types on values.  We should throw helpful error message indicating that this is not an unsupported functionality rather than execution exception.

0: jdbc:drill:zk=local> select attributes from dfs.`/users/nrentachintala/Downloads/yelp/yelp_academic_dataset_business.json` limit 2;
+------------+
| attributes |
+------------+
| {"By Appointment Only":true,"Good For":{},"Ambience":{},"Parking":{},"Music":{},"Hair Types Specialized In":{},"Payment Types":{},"Dietary Restrictions":{}} |
| {"Take-out":true,"Good For":{"dessert":false,"latenight":false,"lunch":true,"dinner":false,"breakfast":false,"brunch":false},"Caters":false,"Noise Level":"average","Takes Reservations":false,"Delivery":false,"Ambience":{"romantic":false,"intimate":false,"touristy":false,"hipster":false,"divey":false,"classy":false,"trendy":false,"upscale":false,"casual":false},"Parking":{"garage":false,"street":false,"validated":false,"lot":true,"valet":false},"Has TV":true,"Outdoor Seating":false,"Attire":"casual","Alcohol":"none","Waiter Service":true,"Accepts Credit Cards":true,"Good for Kids":true,"Good For Groups":true,"Price Range":1,"Music":{},"Hair Types Specialized In":{},"Payment Types":{},"Dietary Restrictions":{}} |
+------------+
2 rows selected (0.274 seconds)
0: jdbc:drill:zk=local> select kvgen(attributes) from dfs.`/users/nrentachintala/Downloads/yelp/yelp_academic_dataset_business.json` limit 2;
Query failed: Query failed: Failure while running fragment., org.apache.drill.exec.vector.complex.impl.NullableBitWriterImpl cannot be cast to org.apache.drill.exec.vector.complex.impl.SingleMapWriter [ 24bcf2c3-c995-4451-8e11-4e804050388f on 10.0.0.6:31010 ]
[ 24bcf2c3-c995-4451-8e11-4e804050388f on 10.0.0.6:31010 ]


Error: exception while executing query: Failure while executing query. (state=,code=0)



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