Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 NK_20
		
			NK_20
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		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?
 NK_20
		
			NK_20
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Nobody?
