Does hive has locks on target tables? How indexing will happen in HIVE SQL? If we do desc for the table which is defined as partition by what it will show? what is buckets and how data will be stored in buckets? how MR will work for the following SQL's? Select * from emp; i guess only one mapreduce jobs starts and no reducer will start. what is split in hive sql? Can we do update using HIVE SQL? No..
Does hive has locks on target tables? YES.
what is buckets and how data will be stored in buckets? it can be use for large data set and use for sampling
Select * from emp I believe there will not be use any map reduce in this
yes that true , hive does not support Update
Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!