Category "hiveql"

How Create a hive external table with parquet format

I am trying to create an external table in hive with the following query in HDFS. CREATE EXTERNAL TABLE `post` ( FileSK STRING, OriginalSK STRING, F

extract a string before certain punctuation regex

How to extract words before the first punctuation | in presto SQL? Table +----+------------------------------------+ | id | title |

How connect to Hive with Squirrel and beeline command

If I enter the remote machine dlw2nia-bd01, and I execute beeline and I execute this connecting string !connect jdbc:hive2://dlw2nia-bd02.walgreens.com:2181,dlw

How to get the partition column names for a table?

I have a table that is partitioned on one or more columns. I can do ... SHOW PARTITIONS table_db.table_1 which gives a list of all partitions like this, year=2

How can I concatenate all values in descending order that have the same primary key in HIVE?

I am using HIVE and I have a table like this: S.no ID applicant_num f_name l_name Primary Key 1 123 202201A1 akhil yadav 123~&~akhil~&~yadav 2 123 2022

Hive SQL: Accessing Last Element of a Json array

I have a json column called "schedule_info" with a format like the following: {schedule: [{"date":"2020-01-01"},{"date":"2021-01-01"},{"date":"2022-01-01"},{"da

Hive query to find conversion ratio

I am trying this query in Hive and it's not working. select ( ( select count(*) from click_streaming where page_

What is the difference between -hivevar and -hiveconf?

From hive -h : --hiveconf <property=value> Use value for given property --hivevar <key=value> Variable subsitution to apply to hive

error : currently subquery expressions are only allowed as where clause predicates in hive

I have written a hive query language as below. It is giving me error as written in title. the query is : SELECT clnt_nbr, CASE WHEN clnt_nbr i

Other Categories