You might want to try map parquet tables by index, rather than column name: SET parquet.column.index.access=true; ... View more

You can pip install impala-shell from github: $ pip install git+git://github.com/dknupp/impala-shell.git afterwards you can run impala-shell to connect to your cluster:   $ impala-shell -i my_impalad.foo.cloudera.com   For more information go to: https://github.com/dknupp/impala-shell ... View more

I'm afraid Impala is not yet able to recognize that only two partitions need to be scanned. We're aware of the gap and that specific optimization is tracked by: https://issues.apache.org/jira/browse/IMPALA-2108   For now, you can manually rewrite your query as suggested in the JIRA as follows: select id, yyyymmdd, group_id, test from dwh.table where ((id='1a' and yyyymmdd=20170815 and group_id=1) OR (id='2b' and yyyymmdd=20170811 and group_id=2)) AND ((yyyymmdd=20170811 and group_id=2) OR (yyyymmdd=20170815 and group_id=1))   or alternatively, use a union:   select id, yyyymmdd, group_id, test from dwh.table where id='1a' and yyyymmdd=20170815 and group_id=1 union all select id, yyyymmdd, group_id, test from dwh.table where id='2b' and yyyymmdd=20170811 and group_id=2   ... View more

Using cloudera manager goto Sentry->Configurations Add users/groups to following property to allow them create/show roles. Smaller fonts are property name in the configuration file while regular fonts are display name of the property in the CM.   Admin Groups sentry.service.admin.group   Allowed Connecting Users sentry.service.allow.connect   ... View more

This is a known bug [1] fixed in the upcoming 2.10.0 release.   [1] https://issues.apache.org/jira/browse/IMPALA-5657 ... View more