TechQA.

Question

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

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

2

Answer

147

Views

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

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

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

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

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

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

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

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

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

FETCH the latest partition from HIVE table

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

score 1963 · 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 717 · Answer 6 · 2018-09-17 20:08:30

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

717 views Asked by Zafar At 17 September 2018 at 20:08

score 1839 · 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 604 · Answer 8 · 2022-03-09 12:08:03

Padding Leading Zero's based on Column Length In Hive

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

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

Replace Digits Using SubString and lpad/rpad

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

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

Replace Digits Using SubString and lpad/rpad In Hive

165 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