Hive Tutorial - 8 : Hive Partitioned table | Create a partition table in HIVE

[@kingdomofgod302]

I was confused with the partition and the bucketing concept of hive but now I got cleared by your wonderful explanation. Thanks for creating this content sir it really helps me a lot.

[@SwatechTalks]

Thanks.. Pls subscribe to my channel and also stay tuned for other important tutorials

[@kingdomofgod302]

Already did and I will also share your channel with all my friends who are learning big data analytics.

[@SwatechTalks]

sure.. Thanks!! this will motivate me to create more content

[@roshanrise]

Nice Content. One quick question.
@10:00 you have executed "Select * from part_people_state". This query also didn't run any MapReduce program. How the Partition table where clause not using mapreduce different from this ?

[@SwatechTalks]

It will scan all the partition of entire table if you dont specify where caluse

[@бруствер-у8с]

thank you so much!!! you're great

[@SwatechTalks]

Thanks, I am very glad that this tutorial helped you.. stay tuned for more

[@бруствер-у8с]

@@SwatechTalks im going to watch all of your videos!)

[@kaladharnaidusompalyam851]

set hive.exec.dynamic.partition.mode=nonstrict . you didn't set this property ,it has to show error na, but not shown .reason
?

[@soumitadalal6130]

thanks.. because of ur query I completed my deliverable.

[@SwatechTalks]

Good to know

[@beastgaming8501]

Good video

[@MDKAMAL-kv8hn]

how can i get this test data

[@SwatechTalks]

There are many websites where you can find the test data. Just google like sample customer / employee / sales data for testing

[@banisettiatchutarao1156]

Clear explanation

[@SwatechTalks]

Thank you

[@seya2183]

Great!

[@bhagirathpandey]

Thanks for this

[@SwatechTalks]

Welcome