Hi,   Can I create a parameterized view in impala   somethig like the below pseudo code:   Create View MyView      as      SELECT col1, col2 col3      FROM table_one      WHERE startdate = ${date1}      and enddate         = ${date2}      ...       ... View more

we need to partition our Hive Table based on date. Date/Month/Year   is it better to use int or string for the partition types. ex: CREATE EXTERNAL TABLE partition (id string, event timestamp and so on) PARTITIONED BY (year INT, month INT, day INT) Stored as Parquet vs   CREATE EXTERNAL TABLE partition (id string, event timestamp and so on) PARTITIONED BY (year string, month string, day string) Stored as Parquet   Noticed that we couldn't do queries like: ... where day > 10 with the string option ... View more

  Can we take advantage of Hive table partitions when querying with impala   Are there any issues or problems we might run into given this scenario.   We currently have partitioned hive tables... will we be missing anything if we dont convert to impala tables ... View more