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 error: parseexception missing EOF

I am not sure what I am doing wrong here: hive> CREATE TABLE default.testtbl(int1 INT,string1 STRING) …

hadoop hive hiveql hcatalog
Is there a way to alter column type in hive table?

The current schema is: hive> describe tableA; OK id int ts timestamp I want to change ts column to …

hive metadata
Connecting to Hive using Beeline

I am trying to connect to hive installed in my machine through Beeline client. when I give the 'beeline' command &…

hadoop hive beeline
Save Spark dataframe as dynamic partitioned table in Hive

I have a sample application working to read from csv files into a dataframe. The dataframe can be stored to …

hadoop apache-spark hive apache-spark-sql spark-dataframe
How to rename a hive table without changing location?

Based on the Hive doc below: Rename Table ALTER TABLE table_name RENAME TO new_table_name; This statement lets …

hadoop hive hiveql
java.lang.RuntimeException:Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient

I have configured my Hive as given on link: http://www.youtube.com/watch?v=Dqo1ahdBK_A, but I …

hive hiveql hive-metastore
Hive query to quickly find table size (number of rows)

Is there a Hive query to quickly find table size (i.e. number of rows) without launching a time-consuming MapReduce …

hadoop hive
Hive cluster by vs order by vs sort by

As far as I understand; sort by only sorts with in the reducer order by orders things globally but shoves …

hadoop hql hive
Convert string to timestamp in Hive

I have the following string representation of a timestamp in my Hive table: 20130502081559999 I need to convert it to a …

hadoop hive hiveql
Hive's unix_timestamp and from_unixtime functions

I am under the impression that unix_timestamp and from_unixtime Hive functions are 'reverse' of each other. When I …

hive hiveql