Qlik Community

Ask a Question

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
NK_20
Contributor
Contributor

Accessing struct fields in HIVE from Qlik Sense

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?

Labels (4)
1 Reply
NK_20
Contributor
Contributor
Author

Nobody?