Starting with the Strategy 9.3.0 and 9.3.1 Mobile Application, we have the following four memory governing limits when running a document or report:
Error in saving the cube, com.microstrategy.webapi.MSTRWebAPIException:() Hortonworks HDP 2.0 Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx Certified Cloudera CDH 5.0 and 5.1 Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx Certified MapR 3.x and 4.x Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx Certified Pivotal HD 2.0.1 and 2.1.0 Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx CertifiedBrowseDenyReadGrantWriteDefaultDeleteDefaultControlDefaultUseGrantExecuteGrantEXPLAIN OperatorsQuery Execution StepsDescriptionSCANSequential ScanscanAmazon Redshift relation scan or table scan operator or step. Scans whole table sequentially from beginning to end; also evaluates query constraints for every row (Filter) if specified with WHERE clause. Also used to run INSERT, UPDATE, and DELETE statements.JOINS: Amazon Redshift uses different join operators based on the physical design of the tables being joined, the location of the data required for the join, and specific attributes of the query itself. Subquery Scan -- Subquery scan and append are used to run UNION queries.Nested LoopnloopLeast optimal join; mainly used for cross-joins (Cartesian products; without a join condition) and some inequality joins.Hash JoinhjoinAlso used for inner joins and left and right outer joins and typically faster than a nested loop join. Hash Join reads the outer table, hashes the joining column, and finds matches in the inner hash table. Step can spill to disk. (Inner input of hjoin is hash step which can be disk-based.)Merge JoinmjoinAlso used for inner joins and outer joins (for join tables that are both distributed and sorted on the joining columns). Typically the fastest Amazon Redshift join algorithm, not including other cost considerations.AGGREGATION: Operators and steps used for queries that involve aggregate functions and GROUP BY operations.AggregateaggrOperator/step for scalar aggregate functions.HashAggregateaggrOperator/step for grouped aggregate functions. Can operate from disk by virtue of hash table spilling to disk.GroupAggregateaggrOperator sometimes chosen for grouped aggregate queries if the Amazon Redshift configuration setting for force_hash_grouping setting is off.SORT: Operators and steps used when queries have to sort or merge result sets.SortsortSort performs the sorting specified by the ORDER BY clause as well as other operations such as UNIONs and joins. Can operate from disk.MergemergeProduces final sorted results of a query based on intermediate sorted results derived from operations performed in parallel.EXCEPT, INTERSECT, and UNION operations:SetOp Except [Distinct]hjoinUsed for EXCEPT queries. Can operate from disk based on virtue of fact that input hash can be disk-based.Hash Intersect [Distinct]hjoinUsed for INTERSECT queries. Can operate from disk based on virtue of fact that input hash can be disk-based.Append [All |Distinct]saveAppend used with Subquery Scan to implement UNION and UNION ALL queries. Can operate from disk based on virtue of "save".Miscellaneous/Other:HashhashUsed for inner joins and left and right outer joins (provides input to a hash join). The Hash operator creates the hash table for the inner table of a join. (The inner table is the table that is checked for matches and, in a join of two tables, is usually the smaller of the two.)LimitlimitEvaluates the LIMIT clause.MaterializesaveMaterialize rows for input to nested loop joins and some merge joins. Can operate from disk.--parseUsed to parse textual input data during a load.--projectUsed to rearrange columns and compute expressions, that is, project data.Result--Run scalar functions that do not involve any table access.--returnReturn rows to the leader or client.Subplan--Used for certain subqueries.UniqueuniqueEliminates duplicates from SELECT DISTINCT and UNION queries.WindowwindowCompute aggregate and ranking window functions. Can operate from disk.Network Operations:Network (Broadcast)bcastBroadcast is also an attribute of Join Explain operators and steps.Network (Distribute)distDistribute rows to compute nodes for parallel processing by data warehouse cluster.Network (Send to Leader)returnSends results back to the leader for further processing.DML Operations (operators that modify data):Insert (using Result)insertInserts data.Delete (Scan + Filter)deleteDeletes data. Can operate from disk.Update (Scan + Filter)delete, insertImplemented as delete and Insert.Customer D11100Customer B 2 2 200 Customer C 3 3 300 Xia D4 4 400 Kris Du 5 5 500 Customer A 1 6 610 Customer E 2 7 720 Customer F 6 8 860 Customer G 7 9 970 Customer H8 10 1080 Customer D11100Customer E27720Xia D44400Kris Du55500Customer G79970 iPad 1iPad 2iPad 3Definition Size (MB)555Data Size (MB)102525Rendering (MB)6060200Max. Data Slice Size (MB)505050 |
Error in saving the cube, com.microstrategy.webapi.MSTRWebAPIException:() Hortonworks HDP 2.0 Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx Certified Cloudera CDH 5.0 and 5.1 Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx Certified MapR 3.x and 4.x Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx Certified Pivotal HD 2.0.1 and 2.1.0 Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx CertifiedBrowseDenyReadGrantWriteDefaultDeleteDefaultControlDefaultUseGrantExecuteGrantEXPLAIN OperatorsQuery Execution StepsDescriptionSCANSequential ScanscanAmazon Redshift relation scan or table scan operator or step. Scans whole table sequentially from beginning to end; also evaluates query constraints for every row (Filter) if specified with WHERE clause. Also used to run INSERT, UPDATE, and DELETE statements.JOINS: Amazon Redshift uses different join operators based on the physical design of the tables being joined, the location of the data required for the join, and specific attributes of the query itself. Subquery Scan -- Subquery scan and append are used to run UNION queries.Nested LoopnloopLeast optimal join; mainly used for cross-joins (Cartesian products; without a join condition) and some inequality joins.Hash JoinhjoinAlso used for inner joins and left and right outer joins and typically faster than a nested loop join. Hash Join reads the outer table, hashes the joining column, and finds matches in the inner hash table. Step can spill to disk. (Inner input of hjoin is hash step which can be disk-based.)Merge JoinmjoinAlso used for inner joins and outer joins (for join tables that are both distributed and sorted on the joining columns). Typically the fastest Amazon Redshift join algorithm, not including other cost considerations.AGGREGATION: Operators and steps used for queries that involve aggregate functions and GROUP BY operations.AggregateaggrOperator/step for scalar aggregate functions.HashAggregateaggrOperator/step for grouped aggregate functions. Can operate from disk by virtue of hash table spilling to disk.GroupAggregateaggrOperator sometimes chosen for grouped aggregate queries if the Amazon Redshift configuration setting for force_hash_grouping setting is off.SORT: Operators and steps used when queries have to sort or merge result sets.SortsortSort performs the sorting specified by the ORDER BY clause as well as other operations such as UNIONs and joins. Can operate from disk.MergemergeProduces final sorted results of a query based on intermediate sorted results derived from operations performed in parallel.EXCEPT, INTERSECT, and UNION operations:SetOp Except [Distinct]hjoinUsed for EXCEPT queries. Can operate from disk based on virtue of fact that input hash can be disk-based.Hash Intersect [Distinct]hjoinUsed for INTERSECT queries. Can operate from disk based on virtue of fact that input hash can be disk-based.Append [All |Distinct]saveAppend used with Subquery Scan to implement UNION and UNION ALL queries. Can operate from disk based on virtue of "save".Miscellaneous/Other:HashhashUsed for inner joins and left and right outer joins (provides input to a hash join). The Hash operator creates the hash table for the inner table of a join. (The inner table is the table that is checked for matches and, in a join of two tables, is usually the smaller of the two.)LimitlimitEvaluates the LIMIT clause.MaterializesaveMaterialize rows for input to nested loop joins and some merge joins. Can operate from disk.--parseUsed to parse textual input data during a load.--projectUsed to rearrange columns and compute expressions, that is, project data.Result--Run scalar functions that do not involve any table access.--returnReturn rows to the leader or client.Subplan--Used for certain subqueries.UniqueuniqueEliminates duplicates from SELECT DISTINCT and UNION queries.WindowwindowCompute aggregate and ranking window functions. Can operate from disk.Network Operations:Network (Broadcast)bcastBroadcast is also an attribute of Join Explain operators and steps.Network (Distribute)distDistribute rows to compute nodes for parallel processing by data warehouse cluster.Network (Send to Leader)returnSends results back to the leader for further processing.DML Operations (operators that modify data):Insert (using Result)insertInserts data.Delete (Scan + Filter)deleteDeletes data. Can operate from disk.Update (Scan + Filter)delete, insertImplemented as delete and Insert.Customer D11100Customer B 2 2 200 Customer C 3 3 300 Xia D4 4 400 Kris Du 5 5 500 Customer A 1 6 610 Customer E 2 7 720 Customer F 6 8 860 Customer G 7 9 970 Customer H8 10 1080 Customer D11100Customer E27720Xia D44400Kris Du55500Customer G79970 iPad 1iPad 2iPad 3Definition Size (MB)555Data Size (MB)102525Rendering (MB)6060200Max. Data Slice Size (MB)505050 |
Error in saving the cube, com.microstrategy.webapi.MSTRWebAPIException:() Hortonworks HDP 2.0 Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx Certified Cloudera CDH 5.0 and 5.1 Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx Certified MapR 3.x and 4.x Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx Certified Pivotal HD 2.0.1 and 2.1.0 Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx CertifiedBrowseDenyReadGrantWriteDefaultDeleteDefaultControlDefaultUseGrantExecuteGrantEXPLAIN OperatorsQuery Execution StepsDescriptionSCANSequential ScanscanAmazon Redshift relation scan or table scan operator or step. Scans whole table sequentially from beginning to end; also evaluates query constraints for every row (Filter) if specified with WHERE clause. Also used to run INSERT, UPDATE, and DELETE statements.JOINS: Amazon Redshift uses different join operators based on the physical design of the tables being joined, the location of the data required for the join, and specific attributes of the query itself. Subquery Scan -- Subquery scan and append are used to run UNION queries.Nested LoopnloopLeast optimal join; mainly used for cross-joins (Cartesian products; without a join condition) and some inequality joins.Hash JoinhjoinAlso used for inner joins and left and right outer joins and typically faster than a nested loop join. Hash Join reads the outer table, hashes the joining column, and finds matches in the inner hash table. Step can spill to disk. (Inner input of hjoin is hash step which can be disk-based.)Merge JoinmjoinAlso used for inner joins and outer joins (for join tables that are both distributed and sorted on the joining columns). Typically the fastest Amazon Redshift join algorithm, not including other cost considerations.AGGREGATION: Operators and steps used for queries that involve aggregate functions and GROUP BY operations.AggregateaggrOperator/step for scalar aggregate functions.HashAggregateaggrOperator/step for grouped aggregate functions. Can operate from disk by virtue of hash table spilling to disk.GroupAggregateaggrOperator sometimes chosen for grouped aggregate queries if the Amazon Redshift configuration setting for force_hash_grouping setting is off.SORT: Operators and steps used when queries have to sort or merge result sets.SortsortSort performs the sorting specified by the ORDER BY clause as well as other operations such as UNIONs and joins. Can operate from disk.MergemergeProduces final sorted results of a query based on intermediate sorted results derived from operations performed in parallel.EXCEPT, INTERSECT, and UNION operations:SetOp Except [Distinct]hjoinUsed for EXCEPT queries. Can operate from disk based on virtue of fact that input hash can be disk-based.Hash Intersect [Distinct]hjoinUsed for INTERSECT queries. Can operate from disk based on virtue of fact that input hash can be disk-based.Append [All |Distinct]saveAppend used with Subquery Scan to implement UNION and UNION ALL queries. Can operate from disk based on virtue of "save".Miscellaneous/Other:HashhashUsed for inner joins and left and right outer joins (provides input to a hash join). The Hash operator creates the hash table for the inner table of a join. (The inner table is the table that is checked for matches and, in a join of two tables, is usually the smaller of the two.)LimitlimitEvaluates the LIMIT clause.MaterializesaveMaterialize rows for input to nested loop joins and some merge joins. Can operate from disk.--parseUsed to parse textual input data during a load.--projectUsed to rearrange columns and compute expressions, that is, project data.Result--Run scalar functions that do not involve any table access.--returnReturn rows to the leader or client.Subplan--Used for certain subqueries.UniqueuniqueEliminates duplicates from SELECT DISTINCT and UNION queries.WindowwindowCompute aggregate and ranking window functions. Can operate from disk.Network Operations:Network (Broadcast)bcastBroadcast is also an attribute of Join Explain operators and steps.Network (Distribute)distDistribute rows to compute nodes for parallel processing by data warehouse cluster.Network (Send to Leader)returnSends results back to the leader for further processing.DML Operations (operators that modify data):Insert (using Result)insertInserts data.Delete (Scan + Filter)deleteDeletes data. Can operate from disk.Update (Scan + Filter)delete, insertImplemented as delete and Insert.Customer D11100Customer B 2 2 200 Customer C 3 3 300 Xia D4 4 400 Kris Du 5 5 500 Customer A 1 6 610 Customer E 2 7 720 Customer F 6 8 860 Customer G 7 9 970 Customer H8 10 1080 Customer D11100Customer E27720Xia D44400Kris Du55500Customer G79970 iPad 1iPad 2iPad 3Definition Size (MB)555Data Size (MB)102525Rendering (MB)6060200Max. Data Slice Size (MB)505050 |
Error in saving the cube, com.microstrategy.webapi.MSTRWebAPIException:() Hortonworks HDP 2.0 Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx Certified Cloudera CDH 5.0 and 5.1 Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx Certified MapR 3.x and 4.x Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx Certified Pivotal HD 2.0.1 and 2.1.0 Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx CertifiedBrowseDenyReadGrantWriteDefaultDeleteDefaultControlDefaultUseGrantExecuteGrantEXPLAIN OperatorsQuery Execution StepsDescriptionSCANSequential ScanscanAmazon Redshift relation scan or table scan operator or step. Scans whole table sequentially from beginning to end; also evaluates query constraints for every row (Filter) if specified with WHERE clause. Also used to run INSERT, UPDATE, and DELETE statements.JOINS: Amazon Redshift uses different join operators based on the physical design of the tables being joined, the location of the data required for the join, and specific attributes of the query itself. Subquery Scan -- Subquery scan and append are used to run UNION queries.Nested LoopnloopLeast optimal join; mainly used for cross-joins (Cartesian products; without a join condition) and some inequality joins.Hash JoinhjoinAlso used for inner joins and left and right outer joins and typically faster than a nested loop join. Hash Join reads the outer table, hashes the joining column, and finds matches in the inner hash table. Step can spill to disk. (Inner input of hjoin is hash step which can be disk-based.)Merge JoinmjoinAlso used for inner joins and outer joins (for join tables that are both distributed and sorted on the joining columns). Typically the fastest Amazon Redshift join algorithm, not including other cost considerations.AGGREGATION: Operators and steps used for queries that involve aggregate functions and GROUP BY operations.AggregateaggrOperator/step for scalar aggregate functions.HashAggregateaggrOperator/step for grouped aggregate functions. Can operate from disk by virtue of hash table spilling to disk.GroupAggregateaggrOperator sometimes chosen for grouped aggregate queries if the Amazon Redshift configuration setting for force_hash_grouping setting is off.SORT: Operators and steps used when queries have to sort or merge result sets.SortsortSort performs the sorting specified by the ORDER BY clause as well as other operations such as UNIONs and joins. Can operate from disk.MergemergeProduces final sorted results of a query based on intermediate sorted results derived from operations performed in parallel.EXCEPT, INTERSECT, and UNION operations:SetOp Except [Distinct]hjoinUsed for EXCEPT queries. Can operate from disk based on virtue of fact that input hash can be disk-based.Hash Intersect [Distinct]hjoinUsed for INTERSECT queries. Can operate from disk based on virtue of fact that input hash can be disk-based.Append [All |Distinct]saveAppend used with Subquery Scan to implement UNION and UNION ALL queries. Can operate from disk based on virtue of "save".Miscellaneous/Other:HashhashUsed for inner joins and left and right outer joins (provides input to a hash join). The Hash operator creates the hash table for the inner table of a join. (The inner table is the table that is checked for matches and, in a join of two tables, is usually the smaller of the two.)LimitlimitEvaluates the LIMIT clause.MaterializesaveMaterialize rows for input to nested loop joins and some merge joins. Can operate from disk.--parseUsed to parse textual input data during a load.--projectUsed to rearrange columns and compute expressions, that is, project data.Result--Run scalar functions that do not involve any table access.--returnReturn rows to the leader or client.Subplan--Used for certain subqueries.UniqueuniqueEliminates duplicates from SELECT DISTINCT and UNION queries.WindowwindowCompute aggregate and ranking window functions. Can operate from disk.Network Operations:Network (Broadcast)bcastBroadcast is also an attribute of Join Explain operators and steps.Network (Distribute)distDistribute rows to compute nodes for parallel processing by data warehouse cluster.Network (Send to Leader)returnSends results back to the leader for further processing.DML Operations (operators that modify data):Insert (using Result)insertInserts data.Delete (Scan + Filter)deleteDeletes data. Can operate from disk.Update (Scan + Filter)delete, insertImplemented as delete and Insert.Customer D11100Customer B 2 2 200 Customer C 3 3 300 Xia D4 4 400 Kris Du 5 5 500 Customer A 1 6 610 Customer E 2 7 720 Customer F 6 8 860 Customer G 7 9 970 Customer H8 10 1080 Customer D11100Customer E27720Xia D44400Kris Du55500Customer G79970 iPad 1iPad 2iPad 3Definition Size (MB)555Data Size (MB)102525Rendering (MB)6060200Max. Data Slice Size (MB)505050 |
Error in saving the cube, com.microstrategy.webapi.MSTRWebAPIException:() Hortonworks HDP 2.0 Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx Certified Cloudera CDH 5.0 and 5.1 Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx Certified MapR 3.x and 4.x Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx Certified Pivotal HD 2.0.1 and 2.1.0 Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx CertifiedBrowseDenyReadGrantWriteDefaultDeleteDefaultControlDefaultUseGrantExecuteGrantEXPLAIN OperatorsQuery Execution StepsDescriptionSCANSequential ScanscanAmazon Redshift relation scan or table scan operator or step. Scans whole table sequentially from beginning to end; also evaluates query constraints for every row (Filter) if specified with WHERE clause. Also used to run INSERT, UPDATE, and DELETE statements.JOINS: Amazon Redshift uses different join operators based on the physical design of the tables being joined, the location of the data required for the join, and specific attributes of the query itself. Subquery Scan -- Subquery scan and append are used to run UNION queries.Nested LoopnloopLeast optimal join; mainly used for cross-joins (Cartesian products; without a join condition) and some inequality joins.Hash JoinhjoinAlso used for inner joins and left and right outer joins and typically faster than a nested loop join. Hash Join reads the outer table, hashes the joining column, and finds matches in the inner hash table. Step can spill to disk. (Inner input of hjoin is hash step which can be disk-based.)Merge JoinmjoinAlso used for inner joins and outer joins (for join tables that are both distributed and sorted on the joining columns). Typically the fastest Amazon Redshift join algorithm, not including other cost considerations.AGGREGATION: Operators and steps used for queries that involve aggregate functions and GROUP BY operations.AggregateaggrOperator/step for scalar aggregate functions.HashAggregateaggrOperator/step for grouped aggregate functions. Can operate from disk by virtue of hash table spilling to disk.GroupAggregateaggrOperator sometimes chosen for grouped aggregate queries if the Amazon Redshift configuration setting for force_hash_grouping setting is off.SORT: Operators and steps used when queries have to sort or merge result sets.SortsortSort performs the sorting specified by the ORDER BY clause as well as other operations such as UNIONs and joins. Can operate from disk.MergemergeProduces final sorted results of a query based on intermediate sorted results derived from operations performed in parallel.EXCEPT, INTERSECT, and UNION operations:SetOp Except [Distinct]hjoinUsed for EXCEPT queries. Can operate from disk based on virtue of fact that input hash can be disk-based.Hash Intersect [Distinct]hjoinUsed for INTERSECT queries. Can operate from disk based on virtue of fact that input hash can be disk-based.Append [All |Distinct]saveAppend used with Subquery Scan to implement UNION and UNION ALL queries. Can operate from disk based on virtue of "save".Miscellaneous/Other:HashhashUsed for inner joins and left and right outer joins (provides input to a hash join). The Hash operator creates the hash table for the inner table of a join. (The inner table is the table that is checked for matches and, in a join of two tables, is usually the smaller of the two.)LimitlimitEvaluates the LIMIT clause.MaterializesaveMaterialize rows for input to nested loop joins and some merge joins. Can operate from disk.--parseUsed to parse textual input data during a load.--projectUsed to rearrange columns and compute expressions, that is, project data.Result--Run scalar functions that do not involve any table access.--returnReturn rows to the leader or client.Subplan--Used for certain subqueries.UniqueuniqueEliminates duplicates from SELECT DISTINCT and UNION queries.WindowwindowCompute aggregate and ranking window functions. Can operate from disk.Network Operations:Network (Broadcast)bcastBroadcast is also an attribute of Join Explain operators and steps.Network (Distribute)distDistribute rows to compute nodes for parallel processing by data warehouse cluster.Network (Send to Leader)returnSends results back to the leader for further processing.DML Operations (operators that modify data):Insert (using Result)insertInserts data.Delete (Scan + Filter)deleteDeletes data. Can operate from disk.Update (Scan + Filter)delete, insertImplemented as delete and Insert.Customer D11100Customer B 2 2 200 Customer C 3 3 300 Xia D4 4 400 Kris Du 5 5 500 Customer A 1 6 610 Customer E 2 7 720 Customer F 6 8 860 Customer G 7 9 970 Customer H8 10 1080 Customer D11100Customer E27720Xia D44400Kris Du55500Customer G79970 iPad 1iPad 2iPad 3Definition Size (MB)555Data Size (MB)102525Rendering (MB)6060200Max. Data Slice Size (MB)505050 |
Error in saving the cube, com.microstrategy.webapi.MSTRWebAPIException:() Hortonworks HDP 2.0 Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx Certified Cloudera CDH 5.0 and 5.1 Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx Certified MapR 3.x and 4.x Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx Certified Pivotal HD 2.0.1 and 2.1.0 Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx CertifiedBrowseDenyReadGrantWriteDefaultDeleteDefaultControlDefaultUseGrantExecuteGrantEXPLAIN OperatorsQuery Execution StepsDescriptionSCANSequential ScanscanAmazon Redshift relation scan or table scan operator or step. Scans whole table sequentially from beginning to end; also evaluates query constraints for every row (Filter) if specified with WHERE clause. Also used to run INSERT, UPDATE, and DELETE statements.JOINS: Amazon Redshift uses different join operators based on the physical design of the tables being joined, the location of the data required for the join, and specific attributes of the query itself. Subquery Scan -- Subquery scan and append are used to run UNION queries.Nested LoopnloopLeast optimal join; mainly used for cross-joins (Cartesian products; without a join condition) and some inequality joins.Hash JoinhjoinAlso used for inner joins and left and right outer joins and typically faster than a nested loop join. Hash Join reads the outer table, hashes the joining column, and finds matches in the inner hash table. Step can spill to disk. (Inner input of hjoin is hash step which can be disk-based.)Merge JoinmjoinAlso used for inner joins and outer joins (for join tables that are both distributed and sorted on the joining columns). Typically the fastest Amazon Redshift join algorithm, not including other cost considerations.AGGREGATION: Operators and steps used for queries that involve aggregate functions and GROUP BY operations.AggregateaggrOperator/step for scalar aggregate functions.HashAggregateaggrOperator/step for grouped aggregate functions. Can operate from disk by virtue of hash table spilling to disk.GroupAggregateaggrOperator sometimes chosen for grouped aggregate queries if the Amazon Redshift configuration setting for force_hash_grouping setting is off.SORT: Operators and steps used when queries have to sort or merge result sets.SortsortSort performs the sorting specified by the ORDER BY clause as well as other operations such as UNIONs and joins. Can operate from disk.MergemergeProduces final sorted results of a query based on intermediate sorted results derived from operations performed in parallel.EXCEPT, INTERSECT, and UNION operations:SetOp Except [Distinct]hjoinUsed for EXCEPT queries. Can operate from disk based on virtue of fact that input hash can be disk-based.Hash Intersect [Distinct]hjoinUsed for INTERSECT queries. Can operate from disk based on virtue of fact that input hash can be disk-based.Append [All |Distinct]saveAppend used with Subquery Scan to implement UNION and UNION ALL queries. Can operate from disk based on virtue of "save".Miscellaneous/Other:HashhashUsed for inner joins and left and right outer joins (provides input to a hash join). The Hash operator creates the hash table for the inner table of a join. (The inner table is the table that is checked for matches and, in a join of two tables, is usually the smaller of the two.)LimitlimitEvaluates the LIMIT clause.MaterializesaveMaterialize rows for input to nested loop joins and some merge joins. Can operate from disk.--parseUsed to parse textual input data during a load.--projectUsed to rearrange columns and compute expressions, that is, project data.Result--Run scalar functions that do not involve any table access.--returnReturn rows to the leader or client.Subplan--Used for certain subqueries.UniqueuniqueEliminates duplicates from SELECT DISTINCT and UNION queries.WindowwindowCompute aggregate and ranking window functions. Can operate from disk.Network Operations:Network (Broadcast)bcastBroadcast is also an attribute of Join Explain operators and steps.Network (Distribute)distDistribute rows to compute nodes for parallel processing by data warehouse cluster.Network (Send to Leader)returnSends results back to the leader for further processing.DML Operations (operators that modify data):Insert (using Result)insertInserts data.Delete (Scan + Filter)deleteDeletes data. Can operate from disk.Update (Scan + Filter)delete, insertImplemented as delete and Insert.Customer D11100Customer B 2 2 200 Customer C 3 3 300 Xia D4 4 400 Kris Du 5 5 500 Customer A 1 6 610 Customer E 2 7 720 Customer F 6 8 860 Customer G 7 9 970 Customer H8 10 1080 Customer D11100Customer E27720Xia D44400Kris Du55500Customer G79970 iPad 1iPad 2iPad 3Definition Size (MB)555Data Size (MB)102525Rendering (MB)6060200Max. Data Slice Size (MB)505050 |
Error in saving the cube, com.microstrategy.webapi.MSTRWebAPIException:() Hortonworks HDP 2.0 Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx Certified Cloudera CDH 5.0 and 5.1 Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx Certified MapR 3.x and 4.x Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx Certified Pivotal HD 2.0.1 and 2.1.0 Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx CertifiedBrowseDenyReadGrantWriteDefaultDeleteDefaultControlDefaultUseGrantExecuteGrantEXPLAIN OperatorsQuery Execution StepsDescriptionSCANSequential ScanscanAmazon Redshift relation scan or table scan operator or step. Scans whole table sequentially from beginning to end; also evaluates query constraints for every row (Filter) if specified with WHERE clause. Also used to run INSERT, UPDATE, and DELETE statements.JOINS: Amazon Redshift uses different join operators based on the physical design of the tables being joined, the location of the data required for the join, and specific attributes of the query itself. Subquery Scan -- Subquery scan and append are used to run UNION queries.Nested LoopnloopLeast optimal join; mainly used for cross-joins (Cartesian products; without a join condition) and some inequality joins.Hash JoinhjoinAlso used for inner joins and left and right outer joins and typically faster than a nested loop join. Hash Join reads the outer table, hashes the joining column, and finds matches in the inner hash table. Step can spill to disk. (Inner input of hjoin is hash step which can be disk-based.)Merge JoinmjoinAlso used for inner joins and outer joins (for join tables that are both distributed and sorted on the joining columns). Typically the fastest Amazon Redshift join algorithm, not including other cost considerations.AGGREGATION: Operators and steps used for queries that involve aggregate functions and GROUP BY operations.AggregateaggrOperator/step for scalar aggregate functions.HashAggregateaggrOperator/step for grouped aggregate functions. Can operate from disk by virtue of hash table spilling to disk.GroupAggregateaggrOperator sometimes chosen for grouped aggregate queries if the Amazon Redshift configuration setting for force_hash_grouping setting is off.SORT: Operators and steps used when queries have to sort or merge result sets.SortsortSort performs the sorting specified by the ORDER BY clause as well as other operations such as UNIONs and joins. Can operate from disk.MergemergeProduces final sorted results of a query based on intermediate sorted results derived from operations performed in parallel.EXCEPT, INTERSECT, and UNION operations:SetOp Except [Distinct]hjoinUsed for EXCEPT queries. Can operate from disk based on virtue of fact that input hash can be disk-based.Hash Intersect [Distinct]hjoinUsed for INTERSECT queries. Can operate from disk based on virtue of fact that input hash can be disk-based.Append [All |Distinct]saveAppend used with Subquery Scan to implement UNION and UNION ALL queries. Can operate from disk based on virtue of "save".Miscellaneous/Other:HashhashUsed for inner joins and left and right outer joins (provides input to a hash join). The Hash operator creates the hash table for the inner table of a join. (The inner table is the table that is checked for matches and, in a join of two tables, is usually the smaller of the two.)LimitlimitEvaluates the LIMIT clause.MaterializesaveMaterialize rows for input to nested loop joins and some merge joins. Can operate from disk.--parseUsed to parse textual input data during a load.--projectUsed to rearrange columns and compute expressions, that is, project data.Result--Run scalar functions that do not involve any table access.--returnReturn rows to the leader or client.Subplan--Used for certain subqueries.UniqueuniqueEliminates duplicates from SELECT DISTINCT and UNION queries.WindowwindowCompute aggregate and ranking window functions. Can operate from disk.Network Operations:Network (Broadcast)bcastBroadcast is also an attribute of Join Explain operators and steps.Network (Distribute)distDistribute rows to compute nodes for parallel processing by data warehouse cluster.Network (Send to Leader)returnSends results back to the leader for further processing.DML Operations (operators that modify data):Insert (using Result)insertInserts data.Delete (Scan + Filter)deleteDeletes data. Can operate from disk.Update (Scan + Filter)delete, insertImplemented as delete and Insert.Customer D11100Customer B 2 2 200 Customer C 3 3 300 Xia D4 4 400 Kris Du 5 5 500 Customer A 1 6 610 Customer E 2 7 720 Customer F 6 8 860 Customer G 7 9 970 Customer H8 10 1080 Customer D11100Customer E27720Xia D44400Kris Du55500Customer G79970 iPad 1iPad 2iPad 3Definition Size (MB)555Data Size (MB)102525Rendering (MB)6060200Max. Data Slice Size (MB)505050 |
Error in saving the cube, com.microstrategy.webapi.MSTRWebAPIException:() Hortonworks HDP 2.0 Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx Certified Cloudera CDH 5.0 and 5.1 Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx Certified MapR 3.x and 4.x Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx Certified Pivotal HD 2.0.1 and 2.1.0 Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx CertifiedBrowseDenyReadGrantWriteDefaultDeleteDefaultControlDefaultUseGrantExecuteGrantEXPLAIN OperatorsQuery Execution StepsDescriptionSCANSequential ScanscanAmazon Redshift relation scan or table scan operator or step. Scans whole table sequentially from beginning to end; also evaluates query constraints for every row (Filter) if specified with WHERE clause. Also used to run INSERT, UPDATE, and DELETE statements.JOINS: Amazon Redshift uses different join operators based on the physical design of the tables being joined, the location of the data required for the join, and specific attributes of the query itself. Subquery Scan -- Subquery scan and append are used to run UNION queries.Nested LoopnloopLeast optimal join; mainly used for cross-joins (Cartesian products; without a join condition) and some inequality joins.Hash JoinhjoinAlso used for inner joins and left and right outer joins and typically faster than a nested loop join. Hash Join reads the outer table, hashes the joining column, and finds matches in the inner hash table. Step can spill to disk. (Inner input of hjoin is hash step which can be disk-based.)Merge JoinmjoinAlso used for inner joins and outer joins (for join tables that are both distributed and sorted on the joining columns). Typically the fastest Amazon Redshift join algorithm, not including other cost considerations.AGGREGATION: Operators and steps used for queries that involve aggregate functions and GROUP BY operations.AggregateaggrOperator/step for scalar aggregate functions.HashAggregateaggrOperator/step for grouped aggregate functions. Can operate from disk by virtue of hash table spilling to disk.GroupAggregateaggrOperator sometimes chosen for grouped aggregate queries if the Amazon Redshift configuration setting for force_hash_grouping setting is off.SORT: Operators and steps used when queries have to sort or merge result sets.SortsortSort performs the sorting specified by the ORDER BY clause as well as other operations such as UNIONs and joins. Can operate from disk.MergemergeProduces final sorted results of a query based on intermediate sorted results derived from operations performed in parallel.EXCEPT, INTERSECT, and UNION operations:SetOp Except [Distinct]hjoinUsed for EXCEPT queries. Can operate from disk based on virtue of fact that input hash can be disk-based.Hash Intersect [Distinct]hjoinUsed for INTERSECT queries. Can operate from disk based on virtue of fact that input hash can be disk-based.Append [All |Distinct]saveAppend used with Subquery Scan to implement UNION and UNION ALL queries. Can operate from disk based on virtue of "save".Miscellaneous/Other:HashhashUsed for inner joins and left and right outer joins (provides input to a hash join). The Hash operator creates the hash table for the inner table of a join. (The inner table is the table that is checked for matches and, in a join of two tables, is usually the smaller of the two.)LimitlimitEvaluates the LIMIT clause.MaterializesaveMaterialize rows for input to nested loop joins and some merge joins. Can operate from disk.--parseUsed to parse textual input data during a load.--projectUsed to rearrange columns and compute expressions, that is, project data.Result--Run scalar functions that do not involve any table access.--returnReturn rows to the leader or client.Subplan--Used for certain subqueries.UniqueuniqueEliminates duplicates from SELECT DISTINCT and UNION queries.WindowwindowCompute aggregate and ranking window functions. Can operate from disk.Network Operations:Network (Broadcast)bcastBroadcast is also an attribute of Join Explain operators and steps.Network (Distribute)distDistribute rows to compute nodes for parallel processing by data warehouse cluster.Network (Send to Leader)returnSends results back to the leader for further processing.DML Operations (operators that modify data):Insert (using Result)insertInserts data.Delete (Scan + Filter)deleteDeletes data. Can operate from disk.Update (Scan + Filter)delete, insertImplemented as delete and Insert.Customer D11100Customer B 2 2 200 Customer C 3 3 300 Xia D4 4 400 Kris Du 5 5 500 Customer A 1 6 610 Customer E 2 7 720 Customer F 6 8 860 Customer G 7 9 970 Customer H8 10 1080 Customer D11100Customer E27720Xia D44400Kris Du55500Customer G79970 iPad 1iPad 2iPad 3Definition Size (MB)555Data Size (MB)102525Rendering (MB)6060200Max. Data Slice Size (MB)505050 |
Error in saving the cube, com.microstrategy.webapi.MSTRWebAPIException:() Hortonworks HDP 2.0 Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx Certified Cloudera CDH 5.0 and 5.1 Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx Certified MapR 3.x and 4.x Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx Certified Pivotal HD 2.0.1 and 2.1.0 Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx CertifiedBrowseDenyReadGrantWriteDefaultDeleteDefaultControlDefaultUseGrantExecuteGrantEXPLAIN OperatorsQuery Execution StepsDescriptionSCANSequential ScanscanAmazon Redshift relation scan or table scan operator or step. Scans whole table sequentially from beginning to end; also evaluates query constraints for every row (Filter) if specified with WHERE clause. Also used to run INSERT, UPDATE, and DELETE statements.JOINS: Amazon Redshift uses different join operators based on the physical design of the tables being joined, the location of the data required for the join, and specific attributes of the query itself. Subquery Scan -- Subquery scan and append are used to run UNION queries.Nested LoopnloopLeast optimal join; mainly used for cross-joins (Cartesian products; without a join condition) and some inequality joins.Hash JoinhjoinAlso used for inner joins and left and right outer joins and typically faster than a nested loop join. Hash Join reads the outer table, hashes the joining column, and finds matches in the inner hash table. Step can spill to disk. (Inner input of hjoin is hash step which can be disk-based.)Merge JoinmjoinAlso used for inner joins and outer joins (for join tables that are both distributed and sorted on the joining columns). Typically the fastest Amazon Redshift join algorithm, not including other cost considerations.AGGREGATION: Operators and steps used for queries that involve aggregate functions and GROUP BY operations.AggregateaggrOperator/step for scalar aggregate functions.HashAggregateaggrOperator/step for grouped aggregate functions. Can operate from disk by virtue of hash table spilling to disk.GroupAggregateaggrOperator sometimes chosen for grouped aggregate queries if the Amazon Redshift configuration setting for force_hash_grouping setting is off.SORT: Operators and steps used when queries have to sort or merge result sets.SortsortSort performs the sorting specified by the ORDER BY clause as well as other operations such as UNIONs and joins. Can operate from disk.MergemergeProduces final sorted results of a query based on intermediate sorted results derived from operations performed in parallel.EXCEPT, INTERSECT, and UNION operations:SetOp Except [Distinct]hjoinUsed for EXCEPT queries. Can operate from disk based on virtue of fact that input hash can be disk-based.Hash Intersect [Distinct]hjoinUsed for INTERSECT queries. Can operate from disk based on virtue of fact that input hash can be disk-based.Append [All |Distinct]saveAppend used with Subquery Scan to implement UNION and UNION ALL queries. Can operate from disk based on virtue of "save".Miscellaneous/Other:HashhashUsed for inner joins and left and right outer joins (provides input to a hash join). The Hash operator creates the hash table for the inner table of a join. (The inner table is the table that is checked for matches and, in a join of two tables, is usually the smaller of the two.)LimitlimitEvaluates the LIMIT clause.MaterializesaveMaterialize rows for input to nested loop joins and some merge joins. Can operate from disk.--parseUsed to parse textual input data during a load.--projectUsed to rearrange columns and compute expressions, that is, project data.Result--Run scalar functions that do not involve any table access.--returnReturn rows to the leader or client.Subplan--Used for certain subqueries.UniqueuniqueEliminates duplicates from SELECT DISTINCT and UNION queries.WindowwindowCompute aggregate and ranking window functions. Can operate from disk.Network Operations:Network (Broadcast)bcastBroadcast is also an attribute of Join Explain operators and steps.Network (Distribute)distDistribute rows to compute nodes for parallel processing by data warehouse cluster.Network (Send to Leader)returnSends results back to the leader for further processing.DML Operations (operators that modify data):Insert (using Result)insertInserts data.Delete (Scan + Filter)deleteDeletes data. Can operate from disk.Update (Scan + Filter)delete, insertImplemented as delete and Insert.Customer D11100Customer B 2 2 200 Customer C 3 3 300 Xia D4 4 400 Kris Du 5 5 500 Customer A 1 6 610 Customer E 2 7 720 Customer F 6 8 860 Customer G 7 9 970 Customer H8 10 1080 Customer D11100Customer E27720Xia D44400Kris Du55500Customer G79970 iPad 1iPad 2iPad 3Definition Size (MB)555Data Size (MB)102525Rendering (MB)6060200Max. Data Slice Size (MB)505050 |
Error in saving the cube, com.microstrategy.webapi.MSTRWebAPIException:() Hortonworks HDP 2.0 Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx Certified Cloudera CDH 5.0 and 5.1 Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx Certified MapR 3.x and 4.x Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx Certified Pivotal HD 2.0.1 and 2.1.0 Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx CertifiedBrowseDenyReadGrantWriteDefaultDeleteDefaultControlDefaultUseGrantExecuteGrantEXPLAIN OperatorsQuery Execution StepsDescriptionSCANSequential ScanscanAmazon Redshift relation scan or table scan operator or step. Scans whole table sequentially from beginning to end; also evaluates query constraints for every row (Filter) if specified with WHERE clause. Also used to run INSERT, UPDATE, and DELETE statements.JOINS: Amazon Redshift uses different join operators based on the physical design of the tables being joined, the location of the data required for the join, and specific attributes of the query itself. Subquery Scan -- Subquery scan and append are used to run UNION queries.Nested LoopnloopLeast optimal join; mainly used for cross-joins (Cartesian products; without a join condition) and some inequality joins.Hash JoinhjoinAlso used for inner joins and left and right outer joins and typically faster than a nested loop join. Hash Join reads the outer table, hashes the joining column, and finds matches in the inner hash table. Step can spill to disk. (Inner input of hjoin is hash step which can be disk-based.)Merge JoinmjoinAlso used for inner joins and outer joins (for join tables that are both distributed and sorted on the joining columns). Typically the fastest Amazon Redshift join algorithm, not including other cost considerations.AGGREGATION: Operators and steps used for queries that involve aggregate functions and GROUP BY operations.AggregateaggrOperator/step for scalar aggregate functions.HashAggregateaggrOperator/step for grouped aggregate functions. Can operate from disk by virtue of hash table spilling to disk.GroupAggregateaggrOperator sometimes chosen for grouped aggregate queries if the Amazon Redshift configuration setting for force_hash_grouping setting is off.SORT: Operators and steps used when queries have to sort or merge result sets.SortsortSort performs the sorting specified by the ORDER BY clause as well as other operations such as UNIONs and joins. Can operate from disk.MergemergeProduces final sorted results of a query based on intermediate sorted results derived from operations performed in parallel.EXCEPT, INTERSECT, and UNION operations:SetOp Except [Distinct]hjoinUsed for EXCEPT queries. Can operate from disk based on virtue of fact that input hash can be disk-based.Hash Intersect [Distinct]hjoinUsed for INTERSECT queries. Can operate from disk based on virtue of fact that input hash can be disk-based.Append [All |Distinct]saveAppend used with Subquery Scan to implement UNION and UNION ALL queries. Can operate from disk based on virtue of "save".Miscellaneous/Other:HashhashUsed for inner joins and left and right outer joins (provides input to a hash join). The Hash operator creates the hash table for the inner table of a join. (The inner table is the table that is checked for matches and, in a join of two tables, is usually the smaller of the two.)LimitlimitEvaluates the LIMIT clause.MaterializesaveMaterialize rows for input to nested loop joins and some merge joins. Can operate from disk.--parseUsed to parse textual input data during a load.--projectUsed to rearrange columns and compute expressions, that is, project data.Result--Run scalar functions that do not involve any table access.--returnReturn rows to the leader or client.Subplan--Used for certain subqueries.UniqueuniqueEliminates duplicates from SELECT DISTINCT and UNION queries.WindowwindowCompute aggregate and ranking window functions. Can operate from disk.Network Operations:Network (Broadcast)bcastBroadcast is also an attribute of Join Explain operators and steps.Network (Distribute)distDistribute rows to compute nodes for parallel processing by data warehouse cluster.Network (Send to Leader)returnSends results back to the leader for further processing.DML Operations (operators that modify data):Insert (using Result)insertInserts data.Delete (Scan + Filter)deleteDeletes data. Can operate from disk.Update (Scan + Filter)delete, insertImplemented as delete and Insert.Customer D11100Customer B 2 2 200 Customer C 3 3 300 Xia D4 4 400 Kris Du 5 5 500 Customer A 1 6 610 Customer E 2 7 720 Customer F 6 8 860 Customer G 7 9 970 Customer H8 10 1080 Customer D11100Customer E27720Xia D44400Kris Du55500Customer G79970 iPad 1iPad 2iPad 3Definition Size (MB)555Data Size (MB)102525Rendering (MB)6060200Max. Data Slice Size (MB)505050 |
Error in saving the cube, com.microstrategy.webapi.MSTRWebAPIException:() Hortonworks HDP 2.0 Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx Certified Cloudera CDH 5.0 and 5.1 Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx Certified MapR 3.x and 4.x Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx Certified Pivotal HD 2.0.1 and 2.1.0 Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx CertifiedBrowseDenyReadGrantWriteDefaultDeleteDefaultControlDefaultUseGrantExecuteGrantEXPLAIN OperatorsQuery Execution StepsDescriptionSCANSequential ScanscanAmazon Redshift relation scan or table scan operator or step. Scans whole table sequentially from beginning to end; also evaluates query constraints for every row (Filter) if specified with WHERE clause. Also used to run INSERT, UPDATE, and DELETE statements.JOINS: Amazon Redshift uses different join operators based on the physical design of the tables being joined, the location of the data required for the join, and specific attributes of the query itself. Subquery Scan -- Subquery scan and append are used to run UNION queries.Nested LoopnloopLeast optimal join; mainly used for cross-joins (Cartesian products; without a join condition) and some inequality joins.Hash JoinhjoinAlso used for inner joins and left and right outer joins and typically faster than a nested loop join. Hash Join reads the outer table, hashes the joining column, and finds matches in the inner hash table. Step can spill to disk. (Inner input of hjoin is hash step which can be disk-based.)Merge JoinmjoinAlso used for inner joins and outer joins (for join tables that are both distributed and sorted on the joining columns). Typically the fastest Amazon Redshift join algorithm, not including other cost considerations.AGGREGATION: Operators and steps used for queries that involve aggregate functions and GROUP BY operations.AggregateaggrOperator/step for scalar aggregate functions.HashAggregateaggrOperator/step for grouped aggregate functions. Can operate from disk by virtue of hash table spilling to disk.GroupAggregateaggrOperator sometimes chosen for grouped aggregate queries if the Amazon Redshift configuration setting for force_hash_grouping setting is off.SORT: Operators and steps used when queries have to sort or merge result sets.SortsortSort performs the sorting specified by the ORDER BY clause as well as other operations such as UNIONs and joins. Can operate from disk.MergemergeProduces final sorted results of a query based on intermediate sorted results derived from operations performed in parallel.EXCEPT, INTERSECT, and UNION operations:SetOp Except [Distinct]hjoinUsed for EXCEPT queries. Can operate from disk based on virtue of fact that input hash can be disk-based.Hash Intersect [Distinct]hjoinUsed for INTERSECT queries. Can operate from disk based on virtue of fact that input hash can be disk-based.Append [All |Distinct]saveAppend used with Subquery Scan to implement UNION and UNION ALL queries. Can operate from disk based on virtue of "save".Miscellaneous/Other:HashhashUsed for inner joins and left and right outer joins (provides input to a hash join). The Hash operator creates the hash table for the inner table of a join. (The inner table is the table that is checked for matches and, in a join of two tables, is usually the smaller of the two.)LimitlimitEvaluates the LIMIT clause.MaterializesaveMaterialize rows for input to nested loop joins and some merge joins. Can operate from disk.--parseUsed to parse textual input data during a load.--projectUsed to rearrange columns and compute expressions, that is, project data.Result--Run scalar functions that do not involve any table access.--returnReturn rows to the leader or client.Subplan--Used for certain subqueries.UniqueuniqueEliminates duplicates from SELECT DISTINCT and UNION queries.WindowwindowCompute aggregate and ranking window functions. Can operate from disk.Network Operations:Network (Broadcast)bcastBroadcast is also an attribute of Join Explain operators and steps.Network (Distribute)distDistribute rows to compute nodes for parallel processing by data warehouse cluster.Network (Send to Leader)returnSends results back to the leader for further processing.DML Operations (operators that modify data):Insert (using Result)insertInserts data.Delete (Scan + Filter)deleteDeletes data. Can operate from disk.Update (Scan + Filter)delete, insertImplemented as delete and Insert.Customer D11100Customer B 2 2 200 Customer C 3 3 300 Xia D4 4 400 Kris Du 5 5 500 Customer A 1 6 610 Customer E 2 7 720 Customer F 6 8 860 Customer G 7 9 970 Customer H8 10 1080 Customer D11100Customer E27720Xia D44400Kris Du55500Customer G79970 iPad 1iPad 2iPad 3Definition Size (MB)555Data Size (MB)102525Rendering (MB)6060200Max. Data Slice Size (MB)505050 |
Error in saving the cube, com.microstrategy.webapi.MSTRWebAPIException:() Hortonworks HDP 2.0 Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx Certified Cloudera CDH 5.0 and 5.1 Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx Certified MapR 3.x and 4.x Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx Certified Pivotal HD 2.0.1 and 2.1.0 Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx CertifiedBrowseDenyReadGrantWriteDefaultDeleteDefaultControlDefaultUseGrantExecuteGrantEXPLAIN OperatorsQuery Execution StepsDescriptionSCANSequential ScanscanAmazon Redshift relation scan or table scan operator or step. Scans whole table sequentially from beginning to end; also evaluates query constraints for every row (Filter) if specified with WHERE clause. Also used to run INSERT, UPDATE, and DELETE statements.JOINS: Amazon Redshift uses different join operators based on the physical design of the tables being joined, the location of the data required for the join, and specific attributes of the query itself. Subquery Scan -- Subquery scan and append are used to run UNION queries.Nested LoopnloopLeast optimal join; mainly used for cross-joins (Cartesian products; without a join condition) and some inequality joins.Hash JoinhjoinAlso used for inner joins and left and right outer joins and typically faster than a nested loop join. Hash Join reads the outer table, hashes the joining column, and finds matches in the inner hash table. Step can spill to disk. (Inner input of hjoin is hash step which can be disk-based.)Merge JoinmjoinAlso used for inner joins and outer joins (for join tables that are both distributed and sorted on the joining columns). Typically the fastest Amazon Redshift join algorithm, not including other cost considerations.AGGREGATION: Operators and steps used for queries that involve aggregate functions and GROUP BY operations.AggregateaggrOperator/step for scalar aggregate functions.HashAggregateaggrOperator/step for grouped aggregate functions. Can operate from disk by virtue of hash table spilling to disk.GroupAggregateaggrOperator sometimes chosen for grouped aggregate queries if the Amazon Redshift configuration setting for force_hash_grouping setting is off.SORT: Operators and steps used when queries have to sort or merge result sets.SortsortSort performs the sorting specified by the ORDER BY clause as well as other operations such as UNIONs and joins. Can operate from disk.MergemergeProduces final sorted results of a query based on intermediate sorted results derived from operations performed in parallel.EXCEPT, INTERSECT, and UNION operations:SetOp Except [Distinct]hjoinUsed for EXCEPT queries. Can operate from disk based on virtue of fact that input hash can be disk-based.Hash Intersect [Distinct]hjoinUsed for INTERSECT queries. Can operate from disk based on virtue of fact that input hash can be disk-based.Append [All |Distinct]saveAppend used with Subquery Scan to implement UNION and UNION ALL queries. Can operate from disk based on virtue of "save".Miscellaneous/Other:HashhashUsed for inner joins and left and right outer joins (provides input to a hash join). The Hash operator creates the hash table for the inner table of a join. (The inner table is the table that is checked for matches and, in a join of two tables, is usually the smaller of the two.)LimitlimitEvaluates the LIMIT clause.MaterializesaveMaterialize rows for input to nested loop joins and some merge joins. Can operate from disk.--parseUsed to parse textual input data during a load.--projectUsed to rearrange columns and compute expressions, that is, project data.Result--Run scalar functions that do not involve any table access.--returnReturn rows to the leader or client.Subplan--Used for certain subqueries.UniqueuniqueEliminates duplicates from SELECT DISTINCT and UNION queries.WindowwindowCompute aggregate and ranking window functions. Can operate from disk.Network Operations:Network (Broadcast)bcastBroadcast is also an attribute of Join Explain operators and steps.Network (Distribute)distDistribute rows to compute nodes for parallel processing by data warehouse cluster.Network (Send to Leader)returnSends results back to the leader for further processing.DML Operations (operators that modify data):Insert (using Result)insertInserts data.Delete (Scan + Filter)deleteDeletes data. Can operate from disk.Update (Scan + Filter)delete, insertImplemented as delete and Insert.Customer D11100Customer B 2 2 200 Customer C 3 3 300 Xia D4 4 400 Kris Du 5 5 500 Customer A 1 6 610 Customer E 2 7 720 Customer F 6 8 860 Customer G 7 9 970 Customer H8 10 1080 Customer D11100Customer E27720Xia D44400Kris Du55500Customer G79970 iPad 1iPad 2iPad 3Definition Size (MB)555Data Size (MB)102525Rendering (MB)6060200Max. Data Slice Size (MB)505050 |
Error in saving the cube, com.microstrategy.webapi.MSTRWebAPIException:() Hortonworks HDP 2.0 Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx Certified Cloudera CDH 5.0 and 5.1 Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx Certified MapR 3.x and 4.x Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx Certified Pivotal HD 2.0.1 and 2.1.0 Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx CertifiedBrowseDenyReadGrantWriteDefaultDeleteDefaultControlDefaultUseGrantExecuteGrantEXPLAIN OperatorsQuery Execution StepsDescriptionSCANSequential ScanscanAmazon Redshift relation scan or table scan operator or step. Scans whole table sequentially from beginning to end; also evaluates query constraints for every row (Filter) if specified with WHERE clause. Also used to run INSERT, UPDATE, and DELETE statements.JOINS: Amazon Redshift uses different join operators based on the physical design of the tables being joined, the location of the data required for the join, and specific attributes of the query itself. Subquery Scan -- Subquery scan and append are used to run UNION queries.Nested LoopnloopLeast optimal join; mainly used for cross-joins (Cartesian products; without a join condition) and some inequality joins.Hash JoinhjoinAlso used for inner joins and left and right outer joins and typically faster than a nested loop join. Hash Join reads the outer table, hashes the joining column, and finds matches in the inner hash table. Step can spill to disk. (Inner input of hjoin is hash step which can be disk-based.)Merge JoinmjoinAlso used for inner joins and outer joins (for join tables that are both distributed and sorted on the joining columns). Typically the fastest Amazon Redshift join algorithm, not including other cost considerations.AGGREGATION: Operators and steps used for queries that involve aggregate functions and GROUP BY operations.AggregateaggrOperator/step for scalar aggregate functions.HashAggregateaggrOperator/step for grouped aggregate functions. Can operate from disk by virtue of hash table spilling to disk.GroupAggregateaggrOperator sometimes chosen for grouped aggregate queries if the Amazon Redshift configuration setting for force_hash_grouping setting is off.SORT: Operators and steps used when queries have to sort or merge result sets.SortsortSort performs the sorting specified by the ORDER BY clause as well as other operations such as UNIONs and joins. Can operate from disk.MergemergeProduces final sorted results of a query based on intermediate sorted results derived from operations performed in parallel.EXCEPT, INTERSECT, and UNION operations:SetOp Except [Distinct]hjoinUsed for EXCEPT queries. Can operate from disk based on virtue of fact that input hash can be disk-based.Hash Intersect [Distinct]hjoinUsed for INTERSECT queries. Can operate from disk based on virtue of fact that input hash can be disk-based.Append [All |Distinct]saveAppend used with Subquery Scan to implement UNION and UNION ALL queries. Can operate from disk based on virtue of "save".Miscellaneous/Other:HashhashUsed for inner joins and left and right outer joins (provides input to a hash join). The Hash operator creates the hash table for the inner table of a join. (The inner table is the table that is checked for matches and, in a join of two tables, is usually the smaller of the two.)LimitlimitEvaluates the LIMIT clause.MaterializesaveMaterialize rows for input to nested loop joins and some merge joins. Can operate from disk.--parseUsed to parse textual input data during a load.--projectUsed to rearrange columns and compute expressions, that is, project data.Result--Run scalar functions that do not involve any table access.--returnReturn rows to the leader or client.Subplan--Used for certain subqueries.UniqueuniqueEliminates duplicates from SELECT DISTINCT and UNION queries.WindowwindowCompute aggregate and ranking window functions. Can operate from disk.Network Operations:Network (Broadcast)bcastBroadcast is also an attribute of Join Explain operators and steps.Network (Distribute)distDistribute rows to compute nodes for parallel processing by data warehouse cluster.Network (Send to Leader)returnSends results back to the leader for further processing.DML Operations (operators that modify data):Insert (using Result)insertInserts data.Delete (Scan + Filter)deleteDeletes data. Can operate from disk.Update (Scan + Filter)delete, insertImplemented as delete and Insert.Customer D11100Customer B 2 2 200 Customer C 3 3 300 Xia D4 4 400 Kris Du 5 5 500 Customer A 1 6 610 Customer E 2 7 720 Customer F 6 8 860 Customer G 7 9 970 Customer H8 10 1080 Customer D11100Customer E27720Xia D44400Kris Du55500Customer G79970 iPad 1iPad 2iPad 3Definition Size (MB)555Data Size (MB)102525Rendering (MB)6060200Max. Data Slice Size (MB)505050 |
Error in saving the cube, com.microstrategy.webapi.MSTRWebAPIException:() Hortonworks HDP 2.0 Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx Certified Cloudera CDH 5.0 and 5.1 Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx Certified MapR 3.x and 4.x Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx Certified Pivotal HD 2.0.1 and 2.1.0 Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx CertifiedBrowseDenyReadGrantWriteDefaultDeleteDefaultControlDefaultUseGrantExecuteGrantEXPLAIN OperatorsQuery Execution StepsDescriptionSCANSequential ScanscanAmazon Redshift relation scan or table scan operator or step. Scans whole table sequentially from beginning to end; also evaluates query constraints for every row (Filter) if specified with WHERE clause. Also used to run INSERT, UPDATE, and DELETE statements.JOINS: Amazon Redshift uses different join operators based on the physical design of the tables being joined, the location of the data required for the join, and specific attributes of the query itself. Subquery Scan -- Subquery scan and append are used to run UNION queries.Nested LoopnloopLeast optimal join; mainly used for cross-joins (Cartesian products; without a join condition) and some inequality joins.Hash JoinhjoinAlso used for inner joins and left and right outer joins and typically faster than a nested loop join. Hash Join reads the outer table, hashes the joining column, and finds matches in the inner hash table. Step can spill to disk. (Inner input of hjoin is hash step which can be disk-based.)Merge JoinmjoinAlso used for inner joins and outer joins (for join tables that are both distributed and sorted on the joining columns). Typically the fastest Amazon Redshift join algorithm, not including other cost considerations.AGGREGATION: Operators and steps used for queries that involve aggregate functions and GROUP BY operations.AggregateaggrOperator/step for scalar aggregate functions.HashAggregateaggrOperator/step for grouped aggregate functions. Can operate from disk by virtue of hash table spilling to disk.GroupAggregateaggrOperator sometimes chosen for grouped aggregate queries if the Amazon Redshift configuration setting for force_hash_grouping setting is off.SORT: Operators and steps used when queries have to sort or merge result sets.SortsortSort performs the sorting specified by the ORDER BY clause as well as other operations such as UNIONs and joins. Can operate from disk.MergemergeProduces final sorted results of a query based on intermediate sorted results derived from operations performed in parallel.EXCEPT, INTERSECT, and UNION operations:SetOp Except [Distinct]hjoinUsed for EXCEPT queries. Can operate from disk based on virtue of fact that input hash can be disk-based.Hash Intersect [Distinct]hjoinUsed for INTERSECT queries. Can operate from disk based on virtue of fact that input hash can be disk-based.Append [All |Distinct]saveAppend used with Subquery Scan to implement UNION and UNION ALL queries. Can operate from disk based on virtue of "save".Miscellaneous/Other:HashhashUsed for inner joins and left and right outer joins (provides input to a hash join). The Hash operator creates the hash table for the inner table of a join. (The inner table is the table that is checked for matches and, in a join of two tables, is usually the smaller of the two.)LimitlimitEvaluates the LIMIT clause.MaterializesaveMaterialize rows for input to nested loop joins and some merge joins. Can operate from disk.--parseUsed to parse textual input data during a load.--projectUsed to rearrange columns and compute expressions, that is, project data.Result--Run scalar functions that do not involve any table access.--returnReturn rows to the leader or client.Subplan--Used for certain subqueries.UniqueuniqueEliminates duplicates from SELECT DISTINCT and UNION queries.WindowwindowCompute aggregate and ranking window functions. Can operate from disk.Network Operations:Network (Broadcast)bcastBroadcast is also an attribute of Join Explain operators and steps.Network (Distribute)distDistribute rows to compute nodes for parallel processing by data warehouse cluster.Network (Send to Leader)returnSends results back to the leader for further processing.DML Operations (operators that modify data):Insert (using Result)insertInserts data.Delete (Scan + Filter)deleteDeletes data. Can operate from disk.Update (Scan + Filter)delete, insertImplemented as delete and Insert.Customer D11100Customer B 2 2 200 Customer C 3 3 300 Xia D4 4 400 Kris Du 5 5 500 Customer A 1 6 610 Customer E 2 7 720 Customer F 6 8 860 Customer G 7 9 970 Customer H8 10 1080 Customer D11100Customer E27720Xia D44400Kris Du55500Customer G79970 iPad 1iPad 2iPad 3Definition Size (MB)555Data Size (MB)102525Rendering (MB)6060200Max. Data Slice Size (MB)505050 |
Error in saving the cube, com.microstrategy.webapi.MSTRWebAPIException:() Hortonworks HDP 2.0 Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx Certified Cloudera CDH 5.0 and 5.1 Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx Certified MapR 3.x and 4.x Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx Certified Pivotal HD 2.0.1 and 2.1.0 Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx CertifiedBrowseDenyReadGrantWriteDefaultDeleteDefaultControlDefaultUseGrantExecuteGrantEXPLAIN OperatorsQuery Execution StepsDescriptionSCANSequential ScanscanAmazon Redshift relation scan or table scan operator or step. Scans whole table sequentially from beginning to end; also evaluates query constraints for every row (Filter) if specified with WHERE clause. Also used to run INSERT, UPDATE, and DELETE statements.JOINS: Amazon Redshift uses different join operators based on the physical design of the tables being joined, the location of the data required for the join, and specific attributes of the query itself. Subquery Scan -- Subquery scan and append are used to run UNION queries.Nested LoopnloopLeast optimal join; mainly used for cross-joins (Cartesian products; without a join condition) and some inequality joins.Hash JoinhjoinAlso used for inner joins and left and right outer joins and typically faster than a nested loop join. Hash Join reads the outer table, hashes the joining column, and finds matches in the inner hash table. Step can spill to disk. (Inner input of hjoin is hash step which can be disk-based.)Merge JoinmjoinAlso used for inner joins and outer joins (for join tables that are both distributed and sorted on the joining columns). Typically the fastest Amazon Redshift join algorithm, not including other cost considerations.AGGREGATION: Operators and steps used for queries that involve aggregate functions and GROUP BY operations.AggregateaggrOperator/step for scalar aggregate functions.HashAggregateaggrOperator/step for grouped aggregate functions. Can operate from disk by virtue of hash table spilling to disk.GroupAggregateaggrOperator sometimes chosen for grouped aggregate queries if the Amazon Redshift configuration setting for force_hash_grouping setting is off.SORT: Operators and steps used when queries have to sort or merge result sets.SortsortSort performs the sorting specified by the ORDER BY clause as well as other operations such as UNIONs and joins. Can operate from disk.MergemergeProduces final sorted results of a query based on intermediate sorted results derived from operations performed in parallel.EXCEPT, INTERSECT, and UNION operations:SetOp Except [Distinct]hjoinUsed for EXCEPT queries. Can operate from disk based on virtue of fact that input hash can be disk-based.Hash Intersect [Distinct]hjoinUsed for INTERSECT queries. Can operate from disk based on virtue of fact that input hash can be disk-based.Append [All |Distinct]saveAppend used with Subquery Scan to implement UNION and UNION ALL queries. Can operate from disk based on virtue of "save".Miscellaneous/Other:HashhashUsed for inner joins and left and right outer joins (provides input to a hash join). The Hash operator creates the hash table for the inner table of a join. (The inner table is the table that is checked for matches and, in a join of two tables, is usually the smaller of the two.)LimitlimitEvaluates the LIMIT clause.MaterializesaveMaterialize rows for input to nested loop joins and some merge joins. Can operate from disk.--parseUsed to parse textual input data during a load.--projectUsed to rearrange columns and compute expressions, that is, project data.Result--Run scalar functions that do not involve any table access.--returnReturn rows to the leader or client.Subplan--Used for certain subqueries.UniqueuniqueEliminates duplicates from SELECT DISTINCT and UNION queries.WindowwindowCompute aggregate and ranking window functions. Can operate from disk.Network Operations:Network (Broadcast)bcastBroadcast is also an attribute of Join Explain operators and steps.Network (Distribute)distDistribute rows to compute nodes for parallel processing by data warehouse cluster.Network (Send to Leader)returnSends results back to the leader for further processing.DML Operations (operators that modify data):Insert (using Result)insertInserts data.Delete (Scan + Filter)deleteDeletes data. Can operate from disk.Update (Scan + Filter)delete, insertImplemented as delete and Insert.Customer D11100Customer B 2 2 200 Customer C 3 3 300 Xia D4 4 400 Kris Du 5 5 500 Customer A 1 6 610 Customer E 2 7 720 Customer F 6 8 860 Customer G 7 9 970 Customer H8 10 1080 Customer D11100Customer E27720Xia D44400Kris Du55500Customer G79970 iPad 1iPad 2iPad 3Definition Size (MB)555Data Size (MB)102525Rendering (MB)6060200Max. Data Slice Size (MB)505050 |
Error in saving the cube, com.microstrategy.webapi.MSTRWebAPIException:() Hortonworks HDP 2.0 Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx Certified Cloudera CDH 5.0 and 5.1 Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx Certified MapR 3.x and 4.x Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx Certified Pivotal HD 2.0.1 and 2.1.0 Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx CertifiedBrowseDenyReadGrantWriteDefaultDeleteDefaultControlDefaultUseGrantExecuteGrantEXPLAIN OperatorsQuery Execution StepsDescriptionSCANSequential ScanscanAmazon Redshift relation scan or table scan operator or step. Scans whole table sequentially from beginning to end; also evaluates query constraints for every row (Filter) if specified with WHERE clause. Also used to run INSERT, UPDATE, and DELETE statements.JOINS: Amazon Redshift uses different join operators based on the physical design of the tables being joined, the location of the data required for the join, and specific attributes of the query itself. Subquery Scan -- Subquery scan and append are used to run UNION queries.Nested LoopnloopLeast optimal join; mainly used for cross-joins (Cartesian products; without a join condition) and some inequality joins.Hash JoinhjoinAlso used for inner joins and left and right outer joins and typically faster than a nested loop join. Hash Join reads the outer table, hashes the joining column, and finds matches in the inner hash table. Step can spill to disk. (Inner input of hjoin is hash step which can be disk-based.)Merge JoinmjoinAlso used for inner joins and outer joins (for join tables that are both distributed and sorted on the joining columns). Typically the fastest Amazon Redshift join algorithm, not including other cost considerations.AGGREGATION: Operators and steps used for queries that involve aggregate functions and GROUP BY operations.AggregateaggrOperator/step for scalar aggregate functions.HashAggregateaggrOperator/step for grouped aggregate functions. Can operate from disk by virtue of hash table spilling to disk.GroupAggregateaggrOperator sometimes chosen for grouped aggregate queries if the Amazon Redshift configuration setting for force_hash_grouping setting is off.SORT: Operators and steps used when queries have to sort or merge result sets.SortsortSort performs the sorting specified by the ORDER BY clause as well as other operations such as UNIONs and joins. Can operate from disk.MergemergeProduces final sorted results of a query based on intermediate sorted results derived from operations performed in parallel.EXCEPT, INTERSECT, and UNION operations:SetOp Except [Distinct]hjoinUsed for EXCEPT queries. Can operate from disk based on virtue of fact that input hash can be disk-based.Hash Intersect [Distinct]hjoinUsed for INTERSECT queries. Can operate from disk based on virtue of fact that input hash can be disk-based.Append [All |Distinct]saveAppend used with Subquery Scan to implement UNION and UNION ALL queries. Can operate from disk based on virtue of "save".Miscellaneous/Other:HashhashUsed for inner joins and left and right outer joins (provides input to a hash join). The Hash operator creates the hash table for the inner table of a join. (The inner table is the table that is checked for matches and, in a join of two tables, is usually the smaller of the two.)LimitlimitEvaluates the LIMIT clause.MaterializesaveMaterialize rows for input to nested loop joins and some merge joins. Can operate from disk.--parseUsed to parse textual input data during a load.--projectUsed to rearrange columns and compute expressions, that is, project data.Result--Run scalar functions that do not involve any table access.--returnReturn rows to the leader or client.Subplan--Used for certain subqueries.UniqueuniqueEliminates duplicates from SELECT DISTINCT and UNION queries.WindowwindowCompute aggregate and ranking window functions. Can operate from disk.Network Operations:Network (Broadcast)bcastBroadcast is also an attribute of Join Explain operators and steps.Network (Distribute)distDistribute rows to compute nodes for parallel processing by data warehouse cluster.Network (Send to Leader)returnSends results back to the leader for further processing.DML Operations (operators that modify data):Insert (using Result)insertInserts data.Delete (Scan + Filter)deleteDeletes data. Can operate from disk.Update (Scan + Filter)delete, insertImplemented as delete and Insert.Customer D11100Customer B 2 2 200 Customer C 3 3 300 Xia D4 4 400 Kris Du 5 5 500 Customer A 1 6 610 Customer E 2 7 720 Customer F 6 8 860 Customer G 7 9 970 Customer H8 10 1080 Customer D11100Customer E27720Xia D44400Kris Du55500Customer G79970 iPad 1iPad 2iPad 3Definition Size (MB)555Data Size (MB)102525Rendering (MB)6060200Max. Data Slice Size (MB)505050 |
Error in saving the cube, com.microstrategy.webapi.MSTRWebAPIException:() Hortonworks HDP 2.0 Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx Certified Cloudera CDH 5.0 and 5.1 Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx Certified MapR 3.x and 4.x Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx Certified Pivotal HD 2.0.1 and 2.1.0 Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx CertifiedBrowseDenyReadGrantWriteDefaultDeleteDefaultControlDefaultUseGrantExecuteGrantEXPLAIN OperatorsQuery Execution StepsDescriptionSCANSequential ScanscanAmazon Redshift relation scan or table scan operator or step. Scans whole table sequentially from beginning to end; also evaluates query constraints for every row (Filter) if specified with WHERE clause. Also used to run INSERT, UPDATE, and DELETE statements.JOINS: Amazon Redshift uses different join operators based on the physical design of the tables being joined, the location of the data required for the join, and specific attributes of the query itself. Subquery Scan -- Subquery scan and append are used to run UNION queries.Nested LoopnloopLeast optimal join; mainly used for cross-joins (Cartesian products; without a join condition) and some inequality joins.Hash JoinhjoinAlso used for inner joins and left and right outer joins and typically faster than a nested loop join. Hash Join reads the outer table, hashes the joining column, and finds matches in the inner hash table. Step can spill to disk. (Inner input of hjoin is hash step which can be disk-based.)Merge JoinmjoinAlso used for inner joins and outer joins (for join tables that are both distributed and sorted on the joining columns). Typically the fastest Amazon Redshift join algorithm, not including other cost considerations.AGGREGATION: Operators and steps used for queries that involve aggregate functions and GROUP BY operations.AggregateaggrOperator/step for scalar aggregate functions.HashAggregateaggrOperator/step for grouped aggregate functions. Can operate from disk by virtue of hash table spilling to disk.GroupAggregateaggrOperator sometimes chosen for grouped aggregate queries if the Amazon Redshift configuration setting for force_hash_grouping setting is off.SORT: Operators and steps used when queries have to sort or merge result sets.SortsortSort performs the sorting specified by the ORDER BY clause as well as other operations such as UNIONs and joins. Can operate from disk.MergemergeProduces final sorted results of a query based on intermediate sorted results derived from operations performed in parallel.EXCEPT, INTERSECT, and UNION operations:SetOp Except [Distinct]hjoinUsed for EXCEPT queries. Can operate from disk based on virtue of fact that input hash can be disk-based.Hash Intersect [Distinct]hjoinUsed for INTERSECT queries. Can operate from disk based on virtue of fact that input hash can be disk-based.Append [All |Distinct]saveAppend used with Subquery Scan to implement UNION and UNION ALL queries. Can operate from disk based on virtue of "save".Miscellaneous/Other:HashhashUsed for inner joins and left and right outer joins (provides input to a hash join). The Hash operator creates the hash table for the inner table of a join. (The inner table is the table that is checked for matches and, in a join of two tables, is usually the smaller of the two.)LimitlimitEvaluates the LIMIT clause.MaterializesaveMaterialize rows for input to nested loop joins and some merge joins. Can operate from disk.--parseUsed to parse textual input data during a load.--projectUsed to rearrange columns and compute expressions, that is, project data.Result--Run scalar functions that do not involve any table access.--returnReturn rows to the leader or client.Subplan--Used for certain subqueries.UniqueuniqueEliminates duplicates from SELECT DISTINCT and UNION queries.WindowwindowCompute aggregate and ranking window functions. Can operate from disk.Network Operations:Network (Broadcast)bcastBroadcast is also an attribute of Join Explain operators and steps.Network (Distribute)distDistribute rows to compute nodes for parallel processing by data warehouse cluster.Network (Send to Leader)returnSends results back to the leader for further processing.DML Operations (operators that modify data):Insert (using Result)insertInserts data.Delete (Scan + Filter)deleteDeletes data. Can operate from disk.Update (Scan + Filter)delete, insertImplemented as delete and Insert.Customer D11100Customer B 2 2 200 Customer C 3 3 300 Xia D4 4 400 Kris Du 5 5 500 Customer A 1 6 610 Customer E 2 7 720 Customer F 6 8 860 Customer G 7 9 970 Customer H8 10 1080 Customer D11100Customer E27720Xia D44400Kris Du55500Customer G79970 iPad 1iPad 2iPad 3Definition Size (MB)555Data Size (MB)102525Rendering (MB)6060200Max. Data Slice Size (MB)505050 |
Error in saving the cube, com.microstrategy.webapi.MSTRWebAPIException:() Hortonworks HDP 2.0 Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx Certified Cloudera CDH 5.0 and 5.1 Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx Certified MapR 3.x and 4.x Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx Certified Pivotal HD 2.0.1 and 2.1.0 Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx CertifiedBrowseDenyReadGrantWriteDefaultDeleteDefaultControlDefaultUseGrantExecuteGrantEXPLAIN OperatorsQuery Execution StepsDescriptionSCANSequential ScanscanAmazon Redshift relation scan or table scan operator or step. Scans whole table sequentially from beginning to end; also evaluates query constraints for every row (Filter) if specified with WHERE clause. Also used to run INSERT, UPDATE, and DELETE statements.JOINS: Amazon Redshift uses different join operators based on the physical design of the tables being joined, the location of the data required for the join, and specific attributes of the query itself. Subquery Scan -- Subquery scan and append are used to run UNION queries.Nested LoopnloopLeast optimal join; mainly used for cross-joins (Cartesian products; without a join condition) and some inequality joins.Hash JoinhjoinAlso used for inner joins and left and right outer joins and typically faster than a nested loop join. Hash Join reads the outer table, hashes the joining column, and finds matches in the inner hash table. Step can spill to disk. (Inner input of hjoin is hash step which can be disk-based.)Merge JoinmjoinAlso used for inner joins and outer joins (for join tables that are both distributed and sorted on the joining columns). Typically the fastest Amazon Redshift join algorithm, not including other cost considerations.AGGREGATION: Operators and steps used for queries that involve aggregate functions and GROUP BY operations.AggregateaggrOperator/step for scalar aggregate functions.HashAggregateaggrOperator/step for grouped aggregate functions. Can operate from disk by virtue of hash table spilling to disk.GroupAggregateaggrOperator sometimes chosen for grouped aggregate queries if the Amazon Redshift configuration setting for force_hash_grouping setting is off.SORT: Operators and steps used when queries have to sort or merge result sets.SortsortSort performs the sorting specified by the ORDER BY clause as well as other operations such as UNIONs and joins. Can operate from disk.MergemergeProduces final sorted results of a query based on intermediate sorted results derived from operations performed in parallel.EXCEPT, INTERSECT, and UNION operations:SetOp Except [Distinct]hjoinUsed for EXCEPT queries. Can operate from disk based on virtue of fact that input hash can be disk-based.Hash Intersect [Distinct]hjoinUsed for INTERSECT queries. Can operate from disk based on virtue of fact that input hash can be disk-based.Append [All |Distinct]saveAppend used with Subquery Scan to implement UNION and UNION ALL queries. Can operate from disk based on virtue of "save".Miscellaneous/Other:HashhashUsed for inner joins and left and right outer joins (provides input to a hash join). The Hash operator creates the hash table for the inner table of a join. (The inner table is the table that is checked for matches and, in a join of two tables, is usually the smaller of the two.)LimitlimitEvaluates the LIMIT clause.MaterializesaveMaterialize rows for input to nested loop joins and some merge joins. Can operate from disk.--parseUsed to parse textual input data during a load.--projectUsed to rearrange columns and compute expressions, that is, project data.Result--Run scalar functions that do not involve any table access.--returnReturn rows to the leader or client.Subplan--Used for certain subqueries.UniqueuniqueEliminates duplicates from SELECT DISTINCT and UNION queries.WindowwindowCompute aggregate and ranking window functions. Can operate from disk.Network Operations:Network (Broadcast)bcastBroadcast is also an attribute of Join Explain operators and steps.Network (Distribute)distDistribute rows to compute nodes for parallel processing by data warehouse cluster.Network (Send to Leader)returnSends results back to the leader for further processing.DML Operations (operators that modify data):Insert (using Result)insertInserts data.Delete (Scan + Filter)deleteDeletes data. Can operate from disk.Update (Scan + Filter)delete, insertImplemented as delete and Insert.Customer D11100Customer B 2 2 200 Customer C 3 3 300 Xia D4 4 400 Kris Du 5 5 500 Customer A 1 6 610 Customer E 2 7 720 Customer F 6 8 860 Customer G 7 9 970 Customer H8 10 1080 Customer D11100Customer E27720Xia D44400Kris Du55500Customer G79970 iPad 1iPad 2iPad 3Definition Size (MB)555Data Size (MB)102525Rendering (MB)6060200Max. Data Slice Size (MB)505050 |
Error in saving the cube, com.microstrategy.webapi.MSTRWebAPIException:() Hortonworks HDP 2.0 Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx Certified Cloudera CDH 5.0 and 5.1 Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx Certified MapR 3.x and 4.x Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx Certified Pivotal HD 2.0.1 and 2.1.0 Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx CertifiedBrowseDenyReadGrantWriteDefaultDeleteDefaultControlDefaultUseGrantExecuteGrantEXPLAIN OperatorsQuery Execution StepsDescriptionSCANSequential ScanscanAmazon Redshift relation scan or table scan operator or step. Scans whole table sequentially from beginning to end; also evaluates query constraints for every row (Filter) if specified with WHERE clause. Also used to run INSERT, UPDATE, and DELETE statements.JOINS: Amazon Redshift uses different join operators based on the physical design of the tables being joined, the location of the data required for the join, and specific attributes of the query itself. Subquery Scan -- Subquery scan and append are used to run UNION queries.Nested LoopnloopLeast optimal join; mainly used for cross-joins (Cartesian products; without a join condition) and some inequality joins.Hash JoinhjoinAlso used for inner joins and left and right outer joins and typically faster than a nested loop join. Hash Join reads the outer table, hashes the joining column, and finds matches in the inner hash table. Step can spill to disk. (Inner input of hjoin is hash step which can be disk-based.)Merge JoinmjoinAlso used for inner joins and outer joins (for join tables that are both distributed and sorted on the joining columns). Typically the fastest Amazon Redshift join algorithm, not including other cost considerations.AGGREGATION: Operators and steps used for queries that involve aggregate functions and GROUP BY operations.AggregateaggrOperator/step for scalar aggregate functions.HashAggregateaggrOperator/step for grouped aggregate functions. Can operate from disk by virtue of hash table spilling to disk.GroupAggregateaggrOperator sometimes chosen for grouped aggregate queries if the Amazon Redshift configuration setting for force_hash_grouping setting is off.SORT: Operators and steps used when queries have to sort or merge result sets.SortsortSort performs the sorting specified by the ORDER BY clause as well as other operations such as UNIONs and joins. Can operate from disk.MergemergeProduces final sorted results of a query based on intermediate sorted results derived from operations performed in parallel.EXCEPT, INTERSECT, and UNION operations:SetOp Except [Distinct]hjoinUsed for EXCEPT queries. Can operate from disk based on virtue of fact that input hash can be disk-based.Hash Intersect [Distinct]hjoinUsed for INTERSECT queries. Can operate from disk based on virtue of fact that input hash can be disk-based.Append [All |Distinct]saveAppend used with Subquery Scan to implement UNION and UNION ALL queries. Can operate from disk based on virtue of "save".Miscellaneous/Other:HashhashUsed for inner joins and left and right outer joins (provides input to a hash join). The Hash operator creates the hash table for the inner table of a join. (The inner table is the table that is checked for matches and, in a join of two tables, is usually the smaller of the two.)LimitlimitEvaluates the LIMIT clause.MaterializesaveMaterialize rows for input to nested loop joins and some merge joins. Can operate from disk.--parseUsed to parse textual input data during a load.--projectUsed to rearrange columns and compute expressions, that is, project data.Result--Run scalar functions that do not involve any table access.--returnReturn rows to the leader or client.Subplan--Used for certain subqueries.UniqueuniqueEliminates duplicates from SELECT DISTINCT and UNION queries.WindowwindowCompute aggregate and ranking window functions. Can operate from disk.Network Operations:Network (Broadcast)bcastBroadcast is also an attribute of Join Explain operators and steps.Network (Distribute)distDistribute rows to compute nodes for parallel processing by data warehouse cluster.Network (Send to Leader)returnSends results back to the leader for further processing.DML Operations (operators that modify data):Insert (using Result)insertInserts data.Delete (Scan + Filter)deleteDeletes data. Can operate from disk.Update (Scan + Filter)delete, insertImplemented as delete and Insert.Customer D11100Customer B 2 2 200 Customer C 3 3 300 Xia D4 4 400 Kris Du 5 5 500 Customer A 1 6 610 Customer E 2 7 720 Customer F 6 8 860 Customer G 7 9 970 Customer H8 10 1080 Customer D11100Customer E27720Xia D44400Kris Du55500Customer G79970 iPad 1iPad 2iPad 3Definition Size (MB)555Data Size (MB)102525Rendering (MB)6060200Max. Data Slice Size (MB)505050 |
Error in saving the cube, com.microstrategy.webapi.MSTRWebAPIException:() Hortonworks HDP 2.0 Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx Certified Cloudera CDH 5.0 and 5.1 Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx Certified MapR 3.x and 4.x Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx Certified Pivotal HD 2.0.1 and 2.1.0 Strategy ODBC driver for Apache Hive Wire Protocol version 7.10.3.xxx CertifiedBrowseDenyReadGrantWriteDefaultDeleteDefaultControlDefaultUseGrantExecuteGrantEXPLAIN OperatorsQuery Execution StepsDescriptionSCANSequential ScanscanAmazon Redshift relation scan or table scan operator or step. Scans whole table sequentially from beginning to end; also evaluates query constraints for every row (Filter) if specified with WHERE clause. Also used to run INSERT, UPDATE, and DELETE statements.JOINS: Amazon Redshift uses different join operators based on the physical design of the tables being joined, the location of the data required for the join, and specific attributes of the query itself. Subquery Scan -- Subquery scan and append are used to run UNION queries.Nested LoopnloopLeast optimal join; mainly used for cross-joins (Cartesian products; without a join condition) and some inequality joins.Hash JoinhjoinAlso used for inner joins and left and right outer joins and typically faster than a nested loop join. Hash Join reads the outer table, hashes the joining column, and finds matches in the inner hash table. Step can spill to disk. (Inner input of hjoin is hash step which can be disk-based.)Merge JoinmjoinAlso used for inner joins and outer joins (for join tables that are both distributed and sorted on the joining columns). Typically the fastest Amazon Redshift join algorithm, not including other cost considerations.AGGREGATION: Operators and steps used for queries that involve aggregate functions and GROUP BY operations.AggregateaggrOperator/step for scalar aggregate functions.HashAggregateaggrOperator/step for grouped aggregate functions. Can operate from disk by virtue of hash table spilling to disk.GroupAggregateaggrOperator sometimes chosen for grouped aggregate queries if the Amazon Redshift configuration setting for force_hash_grouping setting is off.SORT: Operators and steps used when queries have to sort or merge result sets.SortsortSort performs the sorting specified by the ORDER BY clause as well as other operations such as UNIONs and joins. Can operate from disk.MergemergeProduces final sorted results of a query based on intermediate sorted results derived from operations performed in parallel.EXCEPT, INTERSECT, and UNION operations:SetOp Except [Distinct]hjoinUsed for EXCEPT queries. Can operate from disk based on virtue of fact that input hash can be disk-based.Hash Intersect [Distinct]hjoinUsed for INTERSECT queries. Can operate from disk based on virtue of fact that input hash can be disk-based.Append [All |Distinct]saveAppend used with Subquery Scan to implement UNION and UNION ALL queries. Can operate from disk based on virtue of "save".Miscellaneous/Other:HashhashUsed for inner joins and left and right outer joins (provides input to a hash join). The Hash operator creates the hash table for the inner table of a join. (The inner table is the table that is checked for matches and, in a join of two tables, is usually the smaller of the two.)LimitlimitEvaluates the LIMIT clause.MaterializesaveMaterialize rows for input to nested loop joins and some merge joins. Can operate from disk.--parseUsed to parse textual input data during a load.--projectUsed to rearrange columns and compute expressions, that is, project data.Result--Run scalar functions that do not involve any table access.--returnReturn rows to the leader or client.Subplan--Used for certain subqueries.UniqueuniqueEliminates duplicates from SELECT DISTINCT and UNION queries.WindowwindowCompute aggregate and ranking window functions. Can operate from disk.Network Operations:Network (Broadcast)bcastBroadcast is also an attribute of Join Explain operators and steps.Network (Distribute)distDistribute rows to compute nodes for parallel processing by data warehouse cluster.Network (Send to Leader)returnSends results back to the leader for further processing.DML Operations (operators that modify data):Insert (using Result)insertInserts data.Delete (Scan + Filter)deleteDeletes data. Can operate from disk.Update (Scan + Filter)delete, insertImplemented as delete and Insert.Customer D11100Customer B 2 2 200 Customer C 3 3 300 Xia D4 4 400 Kris Du 5 5 500 Customer A 1 6 610 Customer E 2 7 720 Customer F 6 8 860 Customer G 7 9 970 Customer H8 10 1080 Customer D11100Customer E27720Xia D44400Kris Du55500Customer G79970 iPad 1iPad 2iPad 3Definition Size (MB)555Data Size (MB)102525Rendering (MB)6060200Max. Data Slice Size (MB)505050 |
These values were set based on several performance and stability tests. Strategy doesn't recommend to modify them.
KB09830
