Member since
12-20-2018
3
Posts
0
Kudos Received
0
Solutions
01-25-2019
07:48 AM
Can anyone please look at my last post (configs) and let me know if I missed anything else? Thanks.
... View more
01-14-2019
10:18 AM
Trying to understand if this use case is possible. I have a json file that I want to build a hive table with. Here is an example of what I could use to do that - https://pkghosh.wordpress.com/2012/05/06/hive-plays-well-with-json/ . However, once built, I would like to query using impala as below or am I restricted to using Hive queries for sushc tables? SELECT b.blogID, c.email FROM comments a LATERAL VIEW json_tuple(a.value, 'blogID', 'contact') b
AS blogID, contact LATERAL VIEW json_tuple(b.contact, 'email', 'website') c
AS email, website WHERE b.blogID='64FY4D0B28';
... View more
Labels:
- Labels:
-
Apache Hive
-
Apache Impala
-
HDFS