02-08-2019 05:17 PM
Can you say a bit more about what you mean by 'Best Practices'?
From a sql language point of view see https://www.cloudera.com/documentation/enterprise/latest/topics/impala_langref_unsupported.html
From a performance point of view you could google 'hive vs impala' where you can read a lot of opinions :-)
Another useful link about how Hive and Impala work together:
Hope this helps