Welcome To Ask or Share your Answers For Others

Recent questions tagged hiveql

0 votes

651 views

1 answer

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 this: ... get this error: character '@' not supported here Question&Answers:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

419 views

1 answer

hiveql - HIVE select count(*) non null returns higher value than select count(*)

I am currently doing some data exploration with Hive and cannot explain the following behavior. Say I have a ... any hint to explain this behavior ? Thanks Question&Answers:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

773 views

1 answer

hiveql - Hive - No enum constant org.apache.parquet.schema.OriginalType.s (state=,code=0)

I have a table in hive. Which while creating I used the following partitions, format etc. PARTITIONED BY ( ` ... enum-constant-org-apache-parquet-schema-originaltype-s-state-code-0...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

544 views

1 answer

hiveql - How do I repeatedly run a Hive query using each line of a multi line input as the parameter?

Using Hue, I've got a Hive query that will take an input (eg. an ID number) and return a record based on that. I ... -run-a-hive-query-using-each-line-of-a-multi-line-input-as-th...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

515 views

1 answer

hiveql - How to find 5 or more consecutive days in presto

I have the date as below. Here 10/02 and 10/05 should be consider as consecutive days because 10/3 and 10/ ... /questions/65878754/how-to-find-5-or-more-consecutive-days-in-presto...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

679 views

1 answer

hiveql - How to do Hive SQL IF/ELSE query?

In my Hive SQL script I want to do: IF {$user_choice = 1} SELECT a,b,c FROM Table1; ELSE SELECT d,e,f ... ://stackoverflow.com/questions/65906005/how-to-do-hive-sql-if-else-query...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

429 views

1 answer

hiveql - Storing and Query Blank Values in Hive Columns

I have a requirement for storing blank strings of length 1, 2, and 3 in some columns of my Hive table. ... .com/questions/65600096/storing-and-query-blank-values-in-hive-columns...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

469 views

1 answer

hiveql - Schema UNION ALL HIVE should match condition

so I have been trying to make union on 2 tables like this. All those subquerys, qwz and qwx run ... .com/questions/65644900/schema-union-all-hive-should-match-condition...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

444 views

1 answer

hiveql - sum by dates (Hive)

I want to sum(boolean field 1/0, int, "orders") by date(timestamp field, "event_date"). I have tried to do that but ... (event_date) DB HIve Can you help me what I do wrong here ?...

asked Feb 19, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

429 views

1 answer

hiveql - How to get average of all numbers (not a group) in hive?

I have a table, and I wish to add a column which is the average of all lines (not by group). For example, the table is like: ... avg_num a 1 1 b 2 2 So how can I achieve my goal?...

asked Feb 19, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

532 views

1 answer

hiveql - Storing and Query Blank Values in Hive Columns

I have a requirement for storing blank strings of length 1, 2, and 3 in some columns of my Hive table. Storing: If my ... length(col1) from DUMMY5 where col1 = ' '; // 0 record...

asked Feb 19, 2021 in Technique[技术] by 深蓝 (71.8m points)

To see more, click for the full list of questions or popular tags.

...