EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

Apache Drill SQL Query Optimization | Whiteboard Walkthrough


Nigel Collins

Technical Support Intern • Strategy


In this week's Whiteboard Walkthrough video, Neeraja Rentachintala, Senior Director of Product Management at MapR Technologies, explains how Apache Drill optimization achieves interactive performance for low latency SQL queries on very large data sets when working with familiar BI tools such

SYMPTOM
Consider that a user creates a user hierarchy in the Architect graphical interface from the Hierarchy View tab.
The user creates the attributes to the user hierarchy and creates the browse paths between the attributes. When the user clicks on Regular in the toolbar, the layout does not auto arrange the attributes in the hierarchy in a hierarchical pattern:

ka02R000000kcFHQAY_0EM440000002CpN.png

 
CAUSE
This is a known issue with Strategy Architect.
 
ACTION
Contact Strategy Technical Support for an update on the status of this issue.
 
WORKAROUND
After creating the user hierarchy, click on any other hierarchy in the drop down from the toolbar:

ka02R000000kcFHQAY_0EM440000002CpL.png

 
 
 

ka02R000000kcFHQAY_0EM440000002CpJ.png

 
From the drop down in the tool bar, go back to the user hierarchy that you created and now click on Regular. The layout auto arranges the attributes in the hierarchy in a hierarchical pattern:

ka02R000000kcFHQAY_0EM440000002CpO.png

 

ka02R000000kcFHQAY_0EM440000002CpM.png

 
 
 
 


Comment

0 comments

Details

Knowledge Article

Published:

June 6, 2017

Last Updated:

June 6, 2017