As part of the Strategy 2020 Update 2 release, you can now match keywords based on a character pattern. This enables analysts to accommodate use cases with larger datasets, or card sets, in both HyperIntelligence for Web and HyperIntelligence for Office. With this new technique called Pattern Matching, you can avoid downloading (or caching) the keywords in the browser storage for better and faster performance.
If your dataset or card set consists of objects that include a pattern and you have identified that object to be your primary keyword for matching, then you should consider enabling pattern matching for that card set.
Here are some examples of real-world data that have strong patterns:
To use HyperIntelligence, the card author chooses a keyword (or an object from the dataset) and its alternate forms to enable matching on the client. These keywords may or may not have a pattern. In most cases, the keywords are product names, employee names, customer names, and so on. The card author doesn't have to take any extra step in enabling keyword matching since it's set by default and uses the selection under alternate keyword matching section.
Here are some examples of data that do not have strong patterns:
Example: John Smith or Smith, John
Example: Spencer and Kutch Inc.
In summary, we recommend you use pattern matching if you have a large dataset (greater than 500K keywords), and the object you want to match on consists of a pattern.
The table below summarizes the differences between the two types of matching:
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 Pattern Matching Keyword Matching Supports datasets with more than 500,000 unique keywords. Supports datasets up to 500,000 unique keywords. HyperWeb and HyperIntelligence for Office looks for the unique character pattern in the keywords and surfaces cards based on that criteria. HyperWeb and HyperIntelligence for Office looks for an exact match of the keyword that is stored in the dataset. Card keywords are not downloaded (or cached) in the browser storage. Card keywords are downloaded (or cached) in the browser storage. You will not be able to use the search functionality to explore pattern enabled card sets You will be able to use the search functionality to explore non-pattern enabled card sets. |
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 Pattern Matching Keyword Matching Supports datasets with more than 500,000 unique keywords. Supports datasets up to 500,000 unique keywords. HyperWeb and HyperIntelligence for Office looks for the unique character pattern in the keywords and surfaces cards based on that criteria. HyperWeb and HyperIntelligence for Office looks for an exact match of the keyword that is stored in the dataset. Card keywords are not downloaded (or cached) in the browser storage. Card keywords are downloaded (or cached) in the browser storage. You will not be able to use the search functionality to explore pattern enabled card sets You will be able to use the search functionality to explore non-pattern enabled card sets. |
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 Pattern Matching Keyword Matching Supports datasets with more than 500,000 unique keywords. Supports datasets up to 500,000 unique keywords. HyperWeb and HyperIntelligence for Office looks for the unique character pattern in the keywords and surfaces cards based on that criteria. HyperWeb and HyperIntelligence for Office looks for an exact match of the keyword that is stored in the dataset. Card keywords are not downloaded (or cached) in the browser storage. Card keywords are downloaded (or cached) in the browser storage. You will not be able to use the search functionality to explore pattern enabled card sets You will be able to use the search functionality to explore non-pattern enabled card sets. |
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 Pattern Matching Keyword Matching Supports datasets with more than 500,000 unique keywords. Supports datasets up to 500,000 unique keywords. HyperWeb and HyperIntelligence for Office looks for the unique character pattern in the keywords and surfaces cards based on that criteria. HyperWeb and HyperIntelligence for Office looks for an exact match of the keyword that is stored in the dataset. Card keywords are not downloaded (or cached) in the browser storage. Card keywords are downloaded (or cached) in the browser storage. You will not be able to use the search functionality to explore pattern enabled card sets You will be able to use the search functionality to explore non-pattern enabled card sets. |
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 Pattern Matching Keyword Matching Supports datasets with more than 500,000 unique keywords. Supports datasets up to 500,000 unique keywords. HyperWeb and HyperIntelligence for Office looks for the unique character pattern in the keywords and surfaces cards based on that criteria. HyperWeb and HyperIntelligence for Office looks for an exact match of the keyword that is stored in the dataset. Card keywords are not downloaded (or cached) in the browser storage. Card keywords are downloaded (or cached) in the browser storage. You will not be able to use the search functionality to explore pattern enabled card sets You will be able to use the search functionality to explore non-pattern enabled card sets. |
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 Pattern Matching Keyword Matching Supports datasets with more than 500,000 unique keywords. Supports datasets up to 500,000 unique keywords. HyperWeb and HyperIntelligence for Office looks for the unique character pattern in the keywords and surfaces cards based on that criteria. HyperWeb and HyperIntelligence for Office looks for an exact match of the keyword that is stored in the dataset. Card keywords are not downloaded (or cached) in the browser storage. Card keywords are downloaded (or cached) in the browser storage. You will not be able to use the search functionality to explore pattern enabled card sets You will be able to use the search functionality to explore non-pattern enabled card sets. |
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 Pattern Matching Keyword Matching Supports datasets with more than 500,000 unique keywords. Supports datasets up to 500,000 unique keywords. HyperWeb and HyperIntelligence for Office looks for the unique character pattern in the keywords and surfaces cards based on that criteria. HyperWeb and HyperIntelligence for Office looks for an exact match of the keyword that is stored in the dataset. Card keywords are not downloaded (or cached) in the browser storage. Card keywords are downloaded (or cached) in the browser storage. You will not be able to use the search functionality to explore pattern enabled card sets You will be able to use the search functionality to explore non-pattern enabled card sets. |
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 Pattern Matching Keyword Matching Supports datasets with more than 500,000 unique keywords. Supports datasets up to 500,000 unique keywords. HyperWeb and HyperIntelligence for Office looks for the unique character pattern in the keywords and surfaces cards based on that criteria. HyperWeb and HyperIntelligence for Office looks for an exact match of the keyword that is stored in the dataset. Card keywords are not downloaded (or cached) in the browser storage. Card keywords are downloaded (or cached) in the browser storage. You will not be able to use the search functionality to explore pattern enabled card sets You will be able to use the search functionality to explore non-pattern enabled card sets. |
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 Pattern Matching Keyword Matching Supports datasets with more than 500,000 unique keywords. Supports datasets up to 500,000 unique keywords. HyperWeb and HyperIntelligence for Office looks for the unique character pattern in the keywords and surfaces cards based on that criteria. HyperWeb and HyperIntelligence for Office looks for an exact match of the keyword that is stored in the dataset. Card keywords are not downloaded (or cached) in the browser storage. Card keywords are downloaded (or cached) in the browser storage. You will not be able to use the search functionality to explore pattern enabled card sets You will be able to use the search functionality to explore non-pattern enabled card sets. |
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 Pattern Matching Keyword Matching Supports datasets with more than 500,000 unique keywords. Supports datasets up to 500,000 unique keywords. HyperWeb and HyperIntelligence for Office looks for the unique character pattern in the keywords and surfaces cards based on that criteria. HyperWeb and HyperIntelligence for Office looks for an exact match of the keyword that is stored in the dataset. Card keywords are not downloaded (or cached) in the browser storage. Card keywords are downloaded (or cached) in the browser storage. You will not be able to use the search functionality to explore pattern enabled card sets You will be able to use the search functionality to explore non-pattern enabled card sets. |
To learn more on how to enable pattern matching, view our product documentation.
