Hi @archer2012 , that error output doesn't give us a lot of information about what went wrong, but it looks like the connection wasn't successful. I recommend using Beeline in verbose mode from a command line on a suitable node to troubleshoot the connection independently. Once you have the connection to Impala working separately, then you can come back to Airflow and use the working connection settings. ... View more

Thanh you so much @bbreak, the document is so helpful and I read almost the pages. Hope you will help us more, like you did. Have a good day! (UTC +7) ^ ^ ... View more

Closing the connection while the query is still executing is generally not good practice. Think of it as taking ownership for the query you've executed, sort of like turning the lights off before you leave a room. If you're going to close the session (leave the room), you need to first cancel the query that's consuming resources (turn off the lights you turned on). The normal expectation is that an executing query will have an associated active session. ... View more

@Emiller Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future. Thanks ... View more

@data_diver Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future. Thanks ... View more

Any updates to this feature? Is it still experimental? what about parquet formats? ... View more

We're just upgrading from 5.7 to 5.12 and received the same warning. In our case Hive metastore heap size is 12G so the  max message size will be set to 1.2 G . That appears bit scary to me. What are the risks of setting the value such high ?  How can we handle large metastore updates in case that happens ? Do we need to prepare the metastore server i.e. mysql to do somethign differently ? What happens if we don't follow this recommandation ?   Thanks, Sunil ... View more

The bit was an attempt to format the post. It wasn't supposed to be part of the query, sorry about that. Try adding "as" after "create table tester" and before the nested select query. ... View more