My objective is to create a buffer of 1000 m for enode. I used the following query.
CREATE external table enodebuffer (shape binary); INSERT OVERWRITE TABLE enodebuffer SELECT ST_Buffer(enodeaggregate.shape,100) FROM enodeaggregate;
I am able to retrieve the columns and their values (in binary) on hive and also able to get an accurate count of the features. I am also able to get a json fil after using copu from HDFGS (esri git hubtool for hadoop)
However when I use Json to features tool of github I get the following error:
I get the same error whenevr I use the ST_Buffer geometry query. I also tried creating multiple columns with the shape column but to no use.
I took into account all your suggestions but I am not able to get the desired result when I want to create a buffer for 1000's of points. 1) SO for the table, as you had suggested
create external table enodebuffer1 (EnodeBStatus string,shape binary) ROW FORMAT SERDE 'com.esri.hadoop.hive.serde.JsonSerde' STORED AS INPUTFORMAT 'com.esri.json.hadoop.UnenclosedJsonInputFormat' OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat';
2) Then I inserted the values in the table enodebuffer1 using the select query as below
Insert into table enodebuffer1 select enodeaggregate.EnodeBStatus,ST_Buffer(enodeaggregate.shape,1000)from enodeaggregate;
3) I got the result showing that the data has been loaded into the table succesfully, and am also able to retrieve the values using select and limit query.
4) Now the main part is I want to able to see the above results in ArcMap. So I used the esri github tools for hadoop COPY FROM HDFS and JSON TO FEATURES. Copy from HDFS was successful, no error. But json to features it shows the following error (I hope you can see the images)
5) So as Evil Genius had suggested I had tested it with 100 points and it worked fine.Possibly the error is it cannot handle too many vertices. But there has to be a solution because we are planning to migrate terabytes of data into HDFS and using multiple geometry queries to retrieve the desired results.