Re: Hive SQL extension

2020-10-22 Thread Peter Vary
Let's assume that this feature would be useful for Iceberg tables, but useless and even problematic/forbidden for other tables. :) My thinking is, that it could make Hive much more user friendly, if we would allow for extensions in language. With Iceberg integration we plan to do several

Re: Hive SQL extension

2020-10-22 Thread Stamatis Zampetakis
Hi Peter, I am nowhere near being an expert but just wanted to share my thoughts. If I understand correctly you would like some syntactic sugar in Hive to support partitioning as per Iceberg. I cannot tell if that's really useful or not but from my point of view it doesn't seem a very good idea

Hive SQL extension

2020-10-22 Thread Peter Vary
Hi Hive experts, I would like to extend Hive SQL language to provide a way to create Iceberg partitioned tables like this: create table iceberg_test( level string, event_time timestamp, message string, register_time date, telephone array )