I'm having trouble accessing fields within structs from a Qlik Sense data load using the Apache Hive connector.
The following query works fine:
LOAD
[name],
[version],
[records];
SELECT name,
version,
records
FROM [dt_metrics].dataflows
WHERE as_of_date >= '2020-07-29';
But this query:
LOAD
[name],
[version],
[records.total];
SELECT name,
version,
records.total
FROM [dt_metrics].dataflows
WHERE as_of_date >= '2020-07-29';
And this query:
LOAD
[name],
[version],
[total_records];
SELECT name,
version,
records.total as total_records
FROM [dt_metrics].dataflows
WHERE as_of_date >= '2020-07-29';
And many variants of putting quotation marks and square brackets in different places,
Result in the error:
The following error occurred:
Field 'name' not found
The error occurred here:
?
Which I can only assume means it isn't able to parse the query.
n.b. records is a struct containing the field total and this query works fine on the HIVE command line:
SELECT name, records.total FROM dt_metrics.dataflows limit 5;
Does the HIVE connector support accessing struct fields? Is there some special syntax or arrangement of quotation marks that I need to use?
