TechQA.

Question

Optimized way to check if record is present in table 1. If not then check table 2, else return default value

score 142 · Answer 1 · 2020-10-07 16:37:06

2

Answer

142

Views

Optimized way to check if record is present in table 1. If not then check table 2, else return default value

142 views Asked by Ekta J At 07 October 2020 at 16:37

score 346 · Answer 2 · 2021-05-07 01:51:22

Hive nested SUM over partition - error Expression not in GROUP BY key

346 views Asked by d-_-b At 07 May 2021 at 01:51

score 28 · Answer 3 · 2021-05-10 10:00:10

I want to find out the second most populous country from the partitioned table

28 views Asked by Vasudha Jain At 10 May 2021 at 10:00

score 583 · Answer 4 · 2021-05-11 14:38:07

FETCH the latest partition from HIVE table

583 views Asked by jai chu At 11 May 2021 at 14:38

score 1955 · Answer 5 · 2018-11-20 02:22:23

Hive View Query Performance: Union tables with different schemas

1.9k views Asked by NicolasCage At 20 November 2018 at 02:22

score 711 · Answer 6 · 2024-11-21 18:30:31

Data ingest issues hive: java.lang.OutOfMemoryError: unable to create new native thread

711 views Asked by Zafar At 21 November 2024 at 18:30

score 1834 · Answer 7 · 2018-09-25 18:46:53

Populate preceding value using case statement in Hive

1.8k views Asked by nmr At 25 September 2018 at 18:46

score 600 · Answer 8 · 2022-03-09 12:08:03

Padding Leading Zero's based on Column Length In Hive

600 views Asked by Rahul Patidar At 09 March 2022 at 12:08

score 422 · Answer 9 · 2022-03-10 08:11:44

Replace Digits Using SubString and lpad/rpad

422 views Asked by Sonu At 10 March 2022 at 08:11

score 160 · Answer 10 · 2022-03-10 15:04:08

Replace Digits Using SubString and lpad/rpad In Hive

160 views Asked by Sonu At 10 March 2022 at 15:04

TechQA.

List Question

Optimized way to check if record is present in table 1. If not then check table 2, else return default value

Hive nested SUM over partition - error Expression not in GROUP BY key

I want to find out the second most populous country from the partitioned table

FETCH the latest partition from HIVE table

Hive View Query Performance: Union tables with different schemas

Data ingest issues hive: java.lang.OutOfMemoryError: unable to create new native thread

Populate preceding value using case statement in Hive

Padding Leading Zero's based on Column Length In Hive

Replace Digits Using SubString and lpad/rpad

Replace Digits Using SubString and lpad/rpad In Hive

Popular Questions

Popular Tags

Trending Questions