Error with Azure HD Insight

[andymacourek]

I am having an issue with getting data from Azure HD Insight. The code is failing on processing any results, even the base query to get the tables. A row for the table query is coming back as:

{{ "value": [ { "scalarValue": { "type": "NULL", "null": true } }, { "scalarValue": { "type": "STRING", "stringValue": "PRPT" } }, { "scalarValue": { "type": "STRING", "stringValue": "u" } } ] }}
Value: {[ { "scalarValue": { "type": "NULL", "null": true } }, { "scalarValue": { "type": "STRING", "stringValue": "PRPT" } }, { "scalarValue": { "type": "STRING", "stringValue": "u" } } ]}

But the code to get the value is failing with "Specified argument was out of the range of valid values"

My cluster type is
Cluster type, HDInsight version - HBase on Linux (HDI 3.5.1000.0)

[andymacourek]

I updated a method to get it to work:

private TypedValue CurrentRowValue(int ordinal)
{
if (CurrentRow().Value[ordinal].Value.Count > 0)
{
return CurrentRow().Value[ordinal].Value[0];
}
else if (CurrentRow().Value[ordinal].ScalarValue != null)
{
return CurrentRow().Value[ordinal].ScalarValue;
}
else
{
return null;
}

    }

However, I am getting an error "Requested memory of 2194728287234 bytes is larger than global pool of 1233125376 bytes." when I run a query. It works fine with sqlline

[dwdii]

Thanks @andymacourek. We currently have not tested against HDI 3.5 but plan to test and add support under issue #3. We are targeting release by end of January 2017.

By the way, we are open to pull requests. Please consider submitting whatever changes you identify as needed for HDI 3.5 support.