Question : Is there a Automated Hive Database/Schema Designer

Hi All, Does hive a Automated Database Desginer or has anyone tried building it ? Something which is equivalent to Vertica's DDB and Microsoft SQL server's Automated Partitioning Design in Parallel Databases. References are : 1. Automated Partitioning Design in Parallel Database Systems ( http

Re: Using SearchArgumentFacgtory

Thanks for confirming. On Wed, Jul 20, 2016 at 3:27 PM, Prasanth Jayachandran < pjayachand...@hortonworks.com> wrote: > No. Currently there is no way to create SARG directly from string. With > plain strings its hard differentiate column references vs constants vs > expressions. > > You should wr

Re: Using SearchArgumentFacgtory

No. Currently there is no way to create SARG directly from string. With plain strings its hard differentiate column references vs constants vs expressions. You should write a conversion layer that converts the predicates from your custom engine to SARG using the direct APIs. Thanks Prasanth >

Using SearchArgumentFacgtory

I'm using the Search Argument factory to configure my query predicates to the underlying ORC file. I'm receiving the predicates through another a custom engine and not through the Hive. Is there any way i can build the sarg object using some form of a string expression ? Thanks -- shivram mani

Permission to edit wiki

Hi, I submitted a patch for HIVE-14135 recently which needs an update to the wiki. I have created my Confluence account and its username is vihangk1. Can someone please give me the permission to edit the Hive wiki pages? Thanks, Vihang

Error when querying map data type in Hive

Hello, I have a table that is created after an Avro schema. This Avro-schema contains two map type columns defined like this in the schema: {"name": "dimensions", "type": ["null",{"type": "map", "values": "string"}]}, {"name": "metrics", "type": ["null",{"type": "map", "values": "double"}]}, The