Strategy Mobile 10 - 10.7 App for iOS has the following four memory governing limits when running a document or report:
In Strategy Mobile 10.8 App and upper, Data Size and Rendering are merged into a new limit called Runtime Size which is dependent on RAM size of device for both iPhone and iPad as shown below:
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)505050CodeDescription7No certificates available. The SSL certificate was not found. Please confirm the paths used for certificates and file access permissions. 8Certificate validation error. An error is detected while validating a certificate. This error can occur if a root CA certificate is not found in the key database. 9Certificate is not yet valid. This error means that the issuance date of the certificate provided is in the future, so clients will not treat it as valid.10Certificate has expired. This error means that at least one of the certificates provided has expired.11LDAP processing error. An error is detected while setting up the LDAP environment or retrieving an LDAP directory entry.21Unable to verify the first certificate. This error indicates that there is a problem with the certificate chain, and openssl cannot verify that the certificate presented by the device should be trusted.109No certification authority certificates. The key database does not contain any valid certification authority certificates. The SSL run time needs at least one CA or self-signed certificate to perform client authentication. 1GB Device2GB Device4GB DeviceDefinition Size(MB)101010Runtime Size(MB)350 (baseline)7001400Max. Data Slice Size(MB)50100200 |
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)505050CodeDescription7No certificates available. The SSL certificate was not found. Please confirm the paths used for certificates and file access permissions. 8Certificate validation error. An error is detected while validating a certificate. This error can occur if a root CA certificate is not found in the key database. 9Certificate is not yet valid. This error means that the issuance date of the certificate provided is in the future, so clients will not treat it as valid.10Certificate has expired. This error means that at least one of the certificates provided has expired.11LDAP processing error. An error is detected while setting up the LDAP environment or retrieving an LDAP directory entry.21Unable to verify the first certificate. This error indicates that there is a problem with the certificate chain, and openssl cannot verify that the certificate presented by the device should be trusted.109No certification authority certificates. The key database does not contain any valid certification authority certificates. The SSL run time needs at least one CA or self-signed certificate to perform client authentication. 1GB Device2GB Device4GB DeviceDefinition Size(MB)101010Runtime Size(MB)350 (baseline)7001400Max. Data Slice Size(MB)50100200 |
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)505050CodeDescription7No certificates available. The SSL certificate was not found. Please confirm the paths used for certificates and file access permissions. 8Certificate validation error. An error is detected while validating a certificate. This error can occur if a root CA certificate is not found in the key database. 9Certificate is not yet valid. This error means that the issuance date of the certificate provided is in the future, so clients will not treat it as valid.10Certificate has expired. This error means that at least one of the certificates provided has expired.11LDAP processing error. An error is detected while setting up the LDAP environment or retrieving an LDAP directory entry.21Unable to verify the first certificate. This error indicates that there is a problem with the certificate chain, and openssl cannot verify that the certificate presented by the device should be trusted.109No certification authority certificates. The key database does not contain any valid certification authority certificates. The SSL run time needs at least one CA or self-signed certificate to perform client authentication. 1GB Device2GB Device4GB DeviceDefinition Size(MB)101010Runtime Size(MB)350 (baseline)7001400Max. Data Slice Size(MB)50100200 |
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)505050CodeDescription7No certificates available. The SSL certificate was not found. Please confirm the paths used for certificates and file access permissions. 8Certificate validation error. An error is detected while validating a certificate. This error can occur if a root CA certificate is not found in the key database. 9Certificate is not yet valid. This error means that the issuance date of the certificate provided is in the future, so clients will not treat it as valid.10Certificate has expired. This error means that at least one of the certificates provided has expired.11LDAP processing error. An error is detected while setting up the LDAP environment or retrieving an LDAP directory entry.21Unable to verify the first certificate. This error indicates that there is a problem with the certificate chain, and openssl cannot verify that the certificate presented by the device should be trusted.109No certification authority certificates. The key database does not contain any valid certification authority certificates. The SSL run time needs at least one CA or self-signed certificate to perform client authentication. 1GB Device2GB Device4GB DeviceDefinition Size(MB)101010Runtime Size(MB)350 (baseline)7001400Max. Data Slice Size(MB)50100200 |
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)505050CodeDescription7No certificates available. The SSL certificate was not found. Please confirm the paths used for certificates and file access permissions. 8Certificate validation error. An error is detected while validating a certificate. This error can occur if a root CA certificate is not found in the key database. 9Certificate is not yet valid. This error means that the issuance date of the certificate provided is in the future, so clients will not treat it as valid.10Certificate has expired. This error means that at least one of the certificates provided has expired.11LDAP processing error. An error is detected while setting up the LDAP environment or retrieving an LDAP directory entry.21Unable to verify the first certificate. This error indicates that there is a problem with the certificate chain, and openssl cannot verify that the certificate presented by the device should be trusted.109No certification authority certificates. The key database does not contain any valid certification authority certificates. The SSL run time needs at least one CA or self-signed certificate to perform client authentication. 1GB Device2GB Device4GB DeviceDefinition Size(MB)101010Runtime Size(MB)350 (baseline)7001400Max. Data Slice Size(MB)50100200 |
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)505050CodeDescription7No certificates available. The SSL certificate was not found. Please confirm the paths used for certificates and file access permissions. 8Certificate validation error. An error is detected while validating a certificate. This error can occur if a root CA certificate is not found in the key database. 9Certificate is not yet valid. This error means that the issuance date of the certificate provided is in the future, so clients will not treat it as valid.10Certificate has expired. This error means that at least one of the certificates provided has expired.11LDAP processing error. An error is detected while setting up the LDAP environment or retrieving an LDAP directory entry.21Unable to verify the first certificate. This error indicates that there is a problem with the certificate chain, and openssl cannot verify that the certificate presented by the device should be trusted.109No certification authority certificates. The key database does not contain any valid certification authority certificates. The SSL run time needs at least one CA or self-signed certificate to perform client authentication. 1GB Device2GB Device4GB DeviceDefinition Size(MB)101010Runtime Size(MB)350 (baseline)7001400Max. Data Slice Size(MB)50100200 |
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)505050CodeDescription7No certificates available. The SSL certificate was not found. Please confirm the paths used for certificates and file access permissions. 8Certificate validation error. An error is detected while validating a certificate. This error can occur if a root CA certificate is not found in the key database. 9Certificate is not yet valid. This error means that the issuance date of the certificate provided is in the future, so clients will not treat it as valid.10Certificate has expired. This error means that at least one of the certificates provided has expired.11LDAP processing error. An error is detected while setting up the LDAP environment or retrieving an LDAP directory entry.21Unable to verify the first certificate. This error indicates that there is a problem with the certificate chain, and openssl cannot verify that the certificate presented by the device should be trusted.109No certification authority certificates. The key database does not contain any valid certification authority certificates. The SSL run time needs at least one CA or self-signed certificate to perform client authentication. 1GB Device2GB Device4GB DeviceDefinition Size(MB)101010Runtime Size(MB)350 (baseline)7001400Max. Data Slice Size(MB)50100200 |
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)505050CodeDescription7No certificates available. The SSL certificate was not found. Please confirm the paths used for certificates and file access permissions. 8Certificate validation error. An error is detected while validating a certificate. This error can occur if a root CA certificate is not found in the key database. 9Certificate is not yet valid. This error means that the issuance date of the certificate provided is in the future, so clients will not treat it as valid.10Certificate has expired. This error means that at least one of the certificates provided has expired.11LDAP processing error. An error is detected while setting up the LDAP environment or retrieving an LDAP directory entry.21Unable to verify the first certificate. This error indicates that there is a problem with the certificate chain, and openssl cannot verify that the certificate presented by the device should be trusted.109No certification authority certificates. The key database does not contain any valid certification authority certificates. The SSL run time needs at least one CA or self-signed certificate to perform client authentication. 1GB Device2GB Device4GB DeviceDefinition Size(MB)101010Runtime Size(MB)350 (baseline)7001400Max. Data Slice Size(MB)50100200 |
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)505050CodeDescription7No certificates available. The SSL certificate was not found. Please confirm the paths used for certificates and file access permissions. 8Certificate validation error. An error is detected while validating a certificate. This error can occur if a root CA certificate is not found in the key database. 9Certificate is not yet valid. This error means that the issuance date of the certificate provided is in the future, so clients will not treat it as valid.10Certificate has expired. This error means that at least one of the certificates provided has expired.11LDAP processing error. An error is detected while setting up the LDAP environment or retrieving an LDAP directory entry.21Unable to verify the first certificate. This error indicates that there is a problem with the certificate chain, and openssl cannot verify that the certificate presented by the device should be trusted.109No certification authority certificates. The key database does not contain any valid certification authority certificates. The SSL run time needs at least one CA or self-signed certificate to perform client authentication. 1GB Device2GB Device4GB DeviceDefinition Size(MB)101010Runtime Size(MB)350 (baseline)7001400Max. Data Slice Size(MB)50100200 |
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)505050CodeDescription7No certificates available. The SSL certificate was not found. Please confirm the paths used for certificates and file access permissions. 8Certificate validation error. An error is detected while validating a certificate. This error can occur if a root CA certificate is not found in the key database. 9Certificate is not yet valid. This error means that the issuance date of the certificate provided is in the future, so clients will not treat it as valid.10Certificate has expired. This error means that at least one of the certificates provided has expired.11LDAP processing error. An error is detected while setting up the LDAP environment or retrieving an LDAP directory entry.21Unable to verify the first certificate. This error indicates that there is a problem with the certificate chain, and openssl cannot verify that the certificate presented by the device should be trusted.109No certification authority certificates. The key database does not contain any valid certification authority certificates. The SSL run time needs at least one CA or self-signed certificate to perform client authentication. 1GB Device2GB Device4GB DeviceDefinition Size(MB)101010Runtime Size(MB)350 (baseline)7001400Max. Data Slice Size(MB)50100200 |
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)505050CodeDescription7No certificates available. The SSL certificate was not found. Please confirm the paths used for certificates and file access permissions. 8Certificate validation error. An error is detected while validating a certificate. This error can occur if a root CA certificate is not found in the key database. 9Certificate is not yet valid. This error means that the issuance date of the certificate provided is in the future, so clients will not treat it as valid.10Certificate has expired. This error means that at least one of the certificates provided has expired.11LDAP processing error. An error is detected while setting up the LDAP environment or retrieving an LDAP directory entry.21Unable to verify the first certificate. This error indicates that there is a problem with the certificate chain, and openssl cannot verify that the certificate presented by the device should be trusted.109No certification authority certificates. The key database does not contain any valid certification authority certificates. The SSL run time needs at least one CA or self-signed certificate to perform client authentication. 1GB Device2GB Device4GB DeviceDefinition Size(MB)101010Runtime Size(MB)350 (baseline)7001400Max. Data Slice Size(MB)50100200 |
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)505050CodeDescription7No certificates available. The SSL certificate was not found. Please confirm the paths used for certificates and file access permissions. 8Certificate validation error. An error is detected while validating a certificate. This error can occur if a root CA certificate is not found in the key database. 9Certificate is not yet valid. This error means that the issuance date of the certificate provided is in the future, so clients will not treat it as valid.10Certificate has expired. This error means that at least one of the certificates provided has expired.11LDAP processing error. An error is detected while setting up the LDAP environment or retrieving an LDAP directory entry.21Unable to verify the first certificate. This error indicates that there is a problem with the certificate chain, and openssl cannot verify that the certificate presented by the device should be trusted.109No certification authority certificates. The key database does not contain any valid certification authority certificates. The SSL run time needs at least one CA or self-signed certificate to perform client authentication. 1GB Device2GB Device4GB DeviceDefinition Size(MB)101010Runtime Size(MB)350 (baseline)7001400Max. Data Slice Size(MB)50100200 |
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)505050CodeDescription7No certificates available. The SSL certificate was not found. Please confirm the paths used for certificates and file access permissions. 8Certificate validation error. An error is detected while validating a certificate. This error can occur if a root CA certificate is not found in the key database. 9Certificate is not yet valid. This error means that the issuance date of the certificate provided is in the future, so clients will not treat it as valid.10Certificate has expired. This error means that at least one of the certificates provided has expired.11LDAP processing error. An error is detected while setting up the LDAP environment or retrieving an LDAP directory entry.21Unable to verify the first certificate. This error indicates that there is a problem with the certificate chain, and openssl cannot verify that the certificate presented by the device should be trusted.109No certification authority certificates. The key database does not contain any valid certification authority certificates. The SSL run time needs at least one CA or self-signed certificate to perform client authentication. 1GB Device2GB Device4GB DeviceDefinition Size(MB)101010Runtime Size(MB)350 (baseline)7001400Max. Data Slice Size(MB)50100200 |
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)505050CodeDescription7No certificates available. The SSL certificate was not found. Please confirm the paths used for certificates and file access permissions. 8Certificate validation error. An error is detected while validating a certificate. This error can occur if a root CA certificate is not found in the key database. 9Certificate is not yet valid. This error means that the issuance date of the certificate provided is in the future, so clients will not treat it as valid.10Certificate has expired. This error means that at least one of the certificates provided has expired.11LDAP processing error. An error is detected while setting up the LDAP environment or retrieving an LDAP directory entry.21Unable to verify the first certificate. This error indicates that there is a problem with the certificate chain, and openssl cannot verify that the certificate presented by the device should be trusted.109No certification authority certificates. The key database does not contain any valid certification authority certificates. The SSL run time needs at least one CA or self-signed certificate to perform client authentication. 1GB Device2GB Device4GB DeviceDefinition Size(MB)101010Runtime Size(MB)350 (baseline)7001400Max. Data Slice Size(MB)50100200 |
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)505050CodeDescription7No certificates available. The SSL certificate was not found. Please confirm the paths used for certificates and file access permissions. 8Certificate validation error. An error is detected while validating a certificate. This error can occur if a root CA certificate is not found in the key database. 9Certificate is not yet valid. This error means that the issuance date of the certificate provided is in the future, so clients will not treat it as valid.10Certificate has expired. This error means that at least one of the certificates provided has expired.11LDAP processing error. An error is detected while setting up the LDAP environment or retrieving an LDAP directory entry.21Unable to verify the first certificate. This error indicates that there is a problem with the certificate chain, and openssl cannot verify that the certificate presented by the device should be trusted.109No certification authority certificates. The key database does not contain any valid certification authority certificates. The SSL run time needs at least one CA or self-signed certificate to perform client authentication. 1GB Device2GB Device4GB DeviceDefinition Size(MB)101010Runtime Size(MB)350 (baseline)7001400Max. Data Slice Size(MB)50100200 |
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)505050CodeDescription7No certificates available. The SSL certificate was not found. Please confirm the paths used for certificates and file access permissions. 8Certificate validation error. An error is detected while validating a certificate. This error can occur if a root CA certificate is not found in the key database. 9Certificate is not yet valid. This error means that the issuance date of the certificate provided is in the future, so clients will not treat it as valid.10Certificate has expired. This error means that at least one of the certificates provided has expired.11LDAP processing error. An error is detected while setting up the LDAP environment or retrieving an LDAP directory entry.21Unable to verify the first certificate. This error indicates that there is a problem with the certificate chain, and openssl cannot verify that the certificate presented by the device should be trusted.109No certification authority certificates. The key database does not contain any valid certification authority certificates. The SSL run time needs at least one CA or self-signed certificate to perform client authentication. 1GB Device2GB Device4GB DeviceDefinition Size(MB)101010Runtime Size(MB)350 (baseline)7001400Max. Data Slice Size(MB)50100200 |
Note:
Refer to the article below for memory governing limits of Strategy Mobile 10 - 10.7 App for iOS:
KB245092: What are the Memory Governing Limits in the MicroStrategy Mobile 10 - 10.7 App for iOS? KB239114
