I’m trying to get some twitter JSON to show up in Hive and I’m not having any luck. All I get are NULLS returned and no errors. I've tried the native JSON serde as well as the openx serde but get the same results. LOAD DATA INPATH '/tmp/tweets_staging/‘ OVERWRITE INTO tweets; ADD JAR /hadoop/json-serde-1.3.8-SNAPSHOT-jar-with-dependencies.jar; SELECT * FROM tweets LIMIT 100; tweet-table.txt ... View more

I created a table based off the Hive native JSON SerDe. My intention is to create a table for tweets. I've attached tweet-table.txt. The table is created without errors. I then load the data using the LOAD DATA INPATH command and I get no errors. When I try to select data from the table, I get the following error: {"message":"H170 Unable to fetch results. java.io.IOException: org.apache.hadoop.hive.serde2.SerDeException: java.io.IOException: Start token not found where expected [ERROR_STATUS]","status":500,"trace":"org.apache.ambari.view.hive.client.HiveErrorStatusException: H170 Unable to fetch results. java.io.IOException: org.apache.hadoop.hive.serde2.SerDeException: java.io.IOException: Start token not found where expected [ERROR_STATUS]\n\norg.apache.ambari.view.hive.client.HiveErrorStatusException: H170 Unable to fetch results. java.io.IOException: org.apache.hadoop.hive.serde2.SerDeException: java.io.IOException: Start token not found where expected [ERROR_STATUS Any suggestions? ... View more

We have a large VMware installation and are looking for options to deploy HDP to a private cloud using Cloudbreak. We would like to burst to a private cloud as well as bring up and bring down managed HDP services. Is this possible? I know Cloudbreak works with OpenStack but we are looking specifically for a VMware based solution. ... View more