HIVE LLAP Session Unable to write data on my datalake

[#1]

Hi,

I am just trying to insert a record into a hive table using select statement ,LLAP session completes map and reduce phase quickly but after that my session hangs and doesn't pick next set of Sql for the execution . This is very strange scenario.

also sometimes i have observed when i am trying to create a table with LLAP session it hangs forever .

Please suggest me what wrong here ???

[#2]

@Avinash Kumar

Can you check /var/log/hive/hiveserver2Interactive.log for any issues?
Also, verify the query run from Hive interactive UI for Query progression.

[#3]

@Avinash Kumar

Seems like some issue while loading the table from staging directory. Can you please share the table structure?

If it is a transactional/ACID table, then it is known issue that load wouldn't work as LLAP IO does not support ACID tables.

[#4]

@Sindhu we are not using Transnational table , even in LLAP cluster i have disabled "ACID property".

My Table structure is

CREATE EXTERNAL TABLE IF NOT EXISTS ABC ( `col1` String,`col2` Decimal(6,0),`col3` String ) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\u0001' NULL DEFINED AS '' LOCATION 'adl://root.dummy.net/Avinash/abc'

[#5]

I am doing InsertOverwite in this table . sometimes insertoverwrite works but sometimes it hangs, I am affriad with this inconsistency i will not be able to use LLAP in prodcution environment.