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

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

    [ https://issues.apache.org/jira/browse/DRILL-2112?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14297707#comment-14297707 ] 

Hanifi Gunes commented on DRILL-2112:
-------------------------------------

Should be fixed by DRILL-2118

> 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
>            Assignee: Mehant Baid
>             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)