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 ???
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.
@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'
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.