Thanks bro. I was searching for one hour to get clear definition. No one have explained like u. Thanks a lot. you saved my time

Thank you for the effort it really helped me understanding partitions within Hive

Very Informative. thanks for the video

Pls do a vedio on file formats.... parquet avro etc.,

Please do a video on skew and salting..great video by the way .

this playlist of yours is really very helpful.thanks for creating such good contents . one request can you come up with a series on pyspark and mini projects on it.

@dataengineeringvideos

2 жыл бұрын

Sure bro, thanks

Wonderful explanation

Hi bro!, Is it possible partition table to retrieve data?

Sir can we do add partition to dynamic partition??

nice bro,tell me bucketing also

Good explanation.

Hi Gowtham, Thanks for the detailed explanation. It would be great if you can share the scripts. Thanks

insert into user_data_dynamic partition (city) select sno , sname , city from user_data_no_partion; what will be the result of it ? do it will autimatically the different partition for each unique city name automatically?

Can anyone explain me the difference between views and partition in Hive.

hi bro , Great video but I am not able to load a device file to hive. Can you please share detailed process

Can we create the table first and later set the property "set hive.exec.dynamic.partition.mode=nonstrict;" for Dynamic Partition to work ?

is paypal asked about dsa for you while attend interview for paypal sir

Thanks

The partition comments are same or similar for both hive nd sqoop or sqoop has completely different comments? Any one who knows this concept kindly response!

I have seen video on Hive Architecture and Internals from Your channel,there you mentioned hive metadata like tables ,schema will store in either derbi or rdbms if we choose for rdbms like mysql or oracle.But in this video you are showing your hive tables inside hdfs. Either tables should be in derbe or rdbms right?

@dataengineeringvideos

Жыл бұрын

Table data will store in hdfs and Metadata of the table will store in mysql or derby

@bharathibavana3673

Жыл бұрын

@@dataengineeringvideos Okay Thank you

In some business scenario we asuume we have 140 sales organization (countries) Some countries are very big compared to other countries. For example, some sales organization make 30 percent of sales transaction compared to the other 139 sales organization. how to partition data in such scenarios.

Hi I need favor, I have a date column as MM/dd/yyyy hh:mm:ss AM Can you tell me how to partition date format as Year, Month, Day

It had better if you provide that text file. It request for you. Thank you in advnace.

can we not load data into static partitioned table in this way? LOAD DATA INPATH '/hdfs/path/somthing' INTO TABLE Table_name PARTITION(country ="xx")

First bro

I know we can use LOAD command for loading data into static partitioned tables from files.... please correct that. I've tested it.

@dataengineeringvideos

Жыл бұрын

The load command will work but the Data won't be get partitioned , pls run show partition command and test it ,u will not see the Data partitioned