I am having issues creating MongoDB collections from HIVE in HDInsight

I am using HDInsight, and can issue table commands to my MongoDB system, but its not acting like i think it should.I realize that when i create an external table in hive, and give it mongodb properties, it is a shell of a table within hive, and that the real table resides in MongoDB. If I drop t

im having an issue extracting some data from json within hive in hdinsight

and i wonder if this audience could help me out in any way. Here is a link to the request i put out on StackOverflow. I need help retrieving sub arrays from JSON with a HIVE query |   | |   | |   |   |   |   |   | | I need help retrieving sub arrays from JSON with a HIVE ...I have the following

Fw: help with getting the summary of a list of numbers from a json document

I have a json document that has several sub documents. I can query this doc and pull out numbers from a repetitive subdocument. The result is a list within brackets. I want to sum these numbers, and cannot figure out how. Here is a sample document.  {    "_id": "005f2c46-4a70-4fed-a8e9-a44