Accessing struct fields in HIVE from Qlik Sense

NK_20 — Tue, 28 Dec 2021 20:13:46 GMT

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?

Re: Accessing struct fields in HIVE from Qlik Sense

NK_20 — Wed, 19 Aug 2020 11:07:35 GMT

Nobody?

topic Accessing struct fields in HIVE from Qlik Sense in Connectivity & Data Prep

Accessing struct fields in HIVE from Qlik Sense

Re: Accessing struct fields in HIVE from Qlik Sense