Views and Path Filtering for Parquet | Native Object Store | Teradata Vantage - Using Views and Path Filtering - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Native Object Store Getting Started Guide

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
zws1595641486108.ditamap
dita:ditavalPath
hoy1596145193032.ditaval
dita:id
B035-1214
lifecycle
previous
Product Category
Software
Teradata Vantage
There are specific benefits to creating foreign table views, in addition to the usual reasons of security and hiding SQL complexity. These benefits include:
  • Simplified record attribute names.
Follow these recommendations when creating a view on a foreign table:
  • Include both path names and record attributes as columns in the view.
  • It is often the case that the path segment name (such as siteno in data / siteno / year / month / day) is also represented by an attribute in your data. When this is true, Teradata recommends you equate them in the WHERE expression in the view and only specify one of them in the column list. For example, see the use of TheSite in the example view.