Re: JSON support: Hive compatibility or ANSI SQL standard

2018-09-21 Thread Quanlong Huang
Thanks for your reply, friends! Base on the discussion, we'll choose option c. I'll continue to implement Hive's get_json_object function in IMPALA-376. For implementing the ANSI JSON functions, I created a new JIRA (IMPALA-7609) to track it. If anyone has more comments, feel free to reply in

Re: JSON support: Hive compatibility or ANSI SQL standard

2018-09-10 Thread Brock Noland
+1 for option c On Mon, Sep 10, 2018 at 10:34 AM, Tim Armstrong wrote: > I think I agree with Lars. Having the (mostly) Hive-compatible version is > useful if there are shared views between Hive/Impala and for people > migrating queries from Hive or some of the Impala JSON UDFs that I've seen >

Re: JSON support: Hive compatibility or ANSI SQL standard

2018-09-10 Thread Tim Armstrong
I think I agree with Lars. Having the (mostly) Hive-compatible version is useful if there are shared views between Hive/Impala and for people migrating queries from Hive or some of the Impala JSON UDFs that I've seen floating around. On Mon, Sep 10, 2018 at 8:20 AM, Lars Volker wrote: > Thanks

Re: JSON support: Hive compatibility or ANSI SQL standard

2018-09-10 Thread Lars Volker
Thanks for the comprehensive summary, Quanlong. I'm in favor of (c) but I don't feel strongly about the order in which we should prioritize them. Being compatible to Hive and following the SQL standard will help users to switch more easily between systems. I'm not worried about the confusing