Hive SQL [Create| Load| Insert | Show] தமிழ்

[@Sundar_Tenkasi]

Very easy to understand to install hive ,thanks

[@Sundar_Tenkasi]

Thank you Gowtham, this videos makes me more interesting to learn big data Hadoop eco system all components

[@keerthivarmankandaswamy1510]

Hello Gowtham, great video. even though I have used hive this video gave lot more new information. thank you. one question I have is why map reduce is invoked during INSERT command but not during load data?

[@raven5697]

Bro load command la kudutha path windows la eppadi pandrathu bro and hdfs la eppadi store panndrathu

[@karthikjanardhanan6538]

If Hive is just a query engine but the underlying MapReduce that converts and executes them, how did the basic select col from table_name execute without running the MapReduce program?

[@kmohaan]

Hi bro, I am looking for Apache Airflow Orchestrator. I have searched in your links. I am not able to find. could you post related to Airflow in tamil.

[@indianaaruvi1326]

Need Spark Streaming videos bro...

[@hkslife]

I am watching this video for tmrw interview
🤣🤣

[@vigneshkrish4742]

120 secs for single insert? Does real time project use insert in the hive Or it is more of load only?

[@dataengineeringvideos]

120 sec its because of infra that I have in real time yes we use hive for insert / bulk both and it will be faster as well

[@cindyalex4973]

Hi Bro.. Just want to know is it possible to send data from a int column in rdbms to a string column in hive.... Or will we get an error... Pls help me out with this

[@tonydensingh3782]

Brother hdfs vazhiya command pass panni datava store panrom and hive vazhiya command pass panni datava store panrom so what is the difference?

[@dataengineersworld2581]

Bro, HDFS stored already hive data then if you need to that table data means you need to give an path for hive u can done partitioning or anyother else

[@serendipitous263]

I have a silly doubt bro. If Hive is a query engine and you said in Hive architecture that it is not a storage engine, then where will those /user/hive/warehouse/databases and tables be stored in Hive?
I understood that data of Hive tables will be stored in HDFS but what about Hive tables and databases? and you loaded usr_data.txt from HDFS to Hive so where will that be stored in Hive if it's not a storage engine?

[@sugumarn2214]

1. user/hive/warehouse is just a path in HDFS
2. Hive stores the metadata of database in separate RDBMS, so it will refer to the RDBMS to verify the data.
3. Hive can only read the SQL command and all other storage stuff are done in HDFS, so don't get confused by Hive as a directory.