SQL query changes - Aster Client
Teradata Aster® Client Guide
- Product
- Aster Client
- Release Number
- 7.00
- Published
- May 2017
- Language
- English (United States)
- Last Update
- 2018-04-13
- dita:mapPath
- hki1475000360386.ditamap
- dita:ditavalPath
- Generic_no_ie_no_tempfilter.ditaval
- dita:id
- B700-2005
- lifecycle
- previous
- Product Category
- Software
- To use Aster Database’s nPath and other custom SQL-MapReduce functions:
- Reports must be created as free-form SQL type reports in MicroStrategy.
- Teradata Aster recommends that you embed the query in an MicroStrategy logical table and build the reports on top of that.
- If there are existing reports that need to run on Aster Database, some tweaking may be needed in the VLDB Settings of MicroStrategy depending on the complexity of the dynamically generated queries. For example, you may need to turn off TEMP table creation, and so on. This is very rare, but editing VLDB settings can be useful in some cases.
- If the following error appears in queries: “Unable to find function to convert from <x> to <y>”, and if x and y are datatypes like int, float, and so on, then you may need a workaround to explicitly cast the column types. Contact Teradata Support for help on this.