
Contributor II
2022-03-23
03:46 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Wm posting one interview question
Below is one of the interview question..Please find below details
Inline * load[
id,region,sales
1,asia,2000
1,US,3000
2,UK,3900
3,africa,8000
3,south,23000
];
Inline * load[
id,region,sales
4,south,8999
5,east,8999
5,west,7788
1,east,9000
1,east,8999
] where not exist(id);
what is the output of id?
534 Views
2 Replies

Contributor II
2022-03-28
04:13 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Please its important for me, plz answer below query..
load * inline[
id,region,sales
1,asia,2000
1,US,3000
2,UK,3900
3,africa,8000
3,south,23000
];
load * inline[
id,region,sales
4,south,8999
5,east,8999
5,west,7788
1,east,9000
1,east,8999
] where not exist(id);
what is the output of id?
498 Views


Creator
2022-03-28
04:48 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Output table will have below records
id,region,sales
1,asia,2000
1,US,3000
2,UK,3900
3,africa,8000
3,south,23000
4,south,8999
5,east,8999
