Top "Hiveql" questions

Hive insert query like SQL

I am new to hive, and want to know if there is anyway to insert data into hive table like …

sql hadoop hive hiveql

How to select current date in Hive SQL

How do we get the current system date in Hive? In MySQL we have select now(), can any one please …

hive hiveql

How to Update/Drop a Hive Partition?

After adding a partition to an external table in Hive, how can I update/drop it?

hive hiveql

How to set variables in HIVE scripts

I'm looking for the SQL equivalent of SET varname = value in Hive QL I know I can do something like …

hive hiveql

How do I output the results of a HiveQL query to CSV?

we would like to put the results of a Hive query to a CSV file. I thought the command should …

database hadoop hive hiveql

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

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 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

How to export data from Spark SQL to CSV

This command works with HiveQL: insert overwrite directory '/data/home.csv' select * from testtable; But with Spark SQL I'm …

hadoop apache-spark export-to-csv hiveql apache-spark-sql

PySpark: withColumn() with two conditions and three outcomes

I am working with Spark and PySpark. I am trying to achieve the result equivalent to the following pseudocode: df = …

apache-spark hive pyspark apache-spark-sql hiveql