Top "Hive" questions

Hive is a database built on top of Hadoop and facilitates easy data summarization, ad-hoc queries, and the analysis of large datasets stored in Hadoop compatible distributed file system.

Hive: Convert String to Integer

I am looking for a Built-in UDF to convert values of a string column to integer in my hive table …

string hive user-defined-functions hiveql
How to Access Hive via Python?

https://cwiki.apache.org/confluence/display/Hive/HiveClient#HiveClient-Python appears to be outdated. When I add this to /etc/profile: …

python hadoop hive
Difference between Hive internal tables and external tables?

Can anyone tell me the difference between Hive's external table and internal tables. I know the difference comes when dropping …

hadoop hive hiveql
How to save DataFrame directly to Hive?

Is it possible to save DataFrame in spark directly to Hive? I have tried with converting DataFrame to Rdd and …

scala apache-spark hive apache-spark-sql
Hive: how to show all partitions of a table?

I have a table with 1000+ partitions. "Show partitions" command only lists a small number of partitions. How can i show …

hadoop hive
Hive cast string to date dd-MM-yyyy

How can I cast a string in the format 'dd-MM-yyyy' to a date type also in the format 'dd-MM-yyyy' in …

string date casting hive
What is the difference between partitioning and bucketing a table in Hive ?

I know both is performed on a column in the table but how is each operation different.

hadoop hive
How to get/generate the create statement for an existing hive table?

Assuming you have "table" already in Hive, is there a quick way like other databases to be able to get …

sql hive hiveql
Hive query output to file

I run hive query by java code. Example: "SELECT * FROM table WHERE id > 100" How to export result to hdfs …

hadoop hive
Inserting Data into Hive Table

I am new to hive. I have successfully setup a single node hadoop cluster for development purpose and on top …

sql insert hadoop hive