hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
Subject Does Hive SQL support reading data without locking?
Date Tue, 02 Jan 2018 03:59:43 GMT
Hi, All,

We are using Hive to persist our data and we run cron jobs to import new 
data into Hive daily.

At the same time, our users may query data from Hive at the same time by 
using a third party software like Tableau

We found an issue that importing job will fail while the table is queried 
by user because of failing to get an exclusive lock 

Does Hive SQL support reading data without locking (read lock) just like 
'with (nolock)' provided by SQL server?




This email message may contain confidential and/or privileged information. 
If you are not the intended recipient, please do not read, save, forward, 
disclose or copy the contents of this email or open any file attached to 
this email. We will be grateful if you could advise the sender immediately 
by replying this email, and delete this email and any attachment or links 
to this email completely and immediately from your computer system. 

View raw message