SYMPTOM
With a small cube (Less than 20 elements), even though Drill Through Sets are defined, when clicking "Update Now" or "View Data" from Tableau or Excel, Drill Through sets are not picked up and we receive errors like:
[Cloudera][HiveODBC] (35) Error from server: error code: '0' error message: 'Query is not possible: measures (DistinctCountExact([m_qr_id_distinct]), Sum([m_shipped_sum]), DistinctCountEstimate(HyperLogLogAlgorithm(Some(1)),UnaggregatedEstimationStep)([m_project_number_distinct]), Sum([m_mfg_compelete_sum]), Sum([m_fgi_sum]), Sum([m_config_frozen_sum])) are not defined over the product of these dimensions: ([Region] [Nc_Type] [Customer_Name] [Platform_Name] [Pbg_Code] [Project_Number] [Problem_Type_Level2] [DWPART])'.
ROOT CAUSE
Configuration Issue - The default setting is too high.
RESOLUTION
If your cube is small (Less than 20 elements), consider changing Custom Engine Setting "query.drillToRaw.columnCountThreshold" to a value lower than 20. By default this Threshold is set to 20. This threshold controls the minimum number of columns that a query must have to be eligible to be considered a drill-through query.