Re: Support for Hive complex data types.

You are right that Drill does not support the Hive complex types [1]. And I am not aware of any current plans to add support for this. Please follow DRILL-3290 for updates on this. [1]

Re: Error creating view

Can you change the workspace to one where you would like the view to be created in? For example, you could say `use dfsl.tmp;` followed by your create view command. The error here says that the dfsl.default workspace is not writable. On Wed, Jul 20, 2016 at 8:27 AM, Scott Kinney

Support for Hive complex data types.

Hi, I am experimenting with methods to query a data stored on a hdfs using Drill. One option is to use Hive to manage the data and provide table schema/metadata. Few columns in the data contain complex data types which hive converts to hive map, list or struct. According the documentation,

Error creating view

I'm trying to create a view with this command: create view dfsl.smiview as select * from dfsl.`/path/to/view.json`; ? Error: PARSE ERROR: Unable to create or drop tables/views. Schema [dfsl] is immutable. [Error Id: da4ae9f6-016a-487a-a85d-7297d9e22187 on ops-apachedrill:31010]

Partition prunning using CURRENT_DATE?

I'm trying to trigger partition prunning like this: select * from dfs.`json/by-date` where dir0 = cast(current_date as varchar); But apparently, it only works when passing a literal. Am I missing something? Thanks, -- Oscar Morante "Self-education is, I firmly believe, the only