@Override public void toSQL(ColumnResolver resolver, StringBuilder buf) { buf.append(this.getName().toString()); if (!dynColumns.isEmpty()) { buf.append('('); for (ColumnDef def : dynColumns) { buf.append(def); buf.append(','); } buf.setLength(buf.length()-1); buf.append(')'); } if (this.getAlias() != null) buf.append(" " + this.getAlias()); if (this.getTableSamplingRate() != null) buf.append(" TABLESAMPLE " + this.getTableSamplingRate()); buf.append(' '); }
@Override public TableNode visit(NamedTableNode namedTableNode) throws SQLException { TableRef tableRef = resolveTable(namedTableNode.getAlias(), namedTableNode.getName()); TableRef replaceRef = replacement.get(tableRef); if (replaceRef == null) return namedTableNode; String alias = namedTableNode.getAlias(); return FACTORY.namedTable(alias == null ? null : '"' + alias + '"', getReplacedTableName(replaceRef), namedTableNode.getDynamicColumns(), namedTableNode.getTableSamplingRate()); }
@Override public Pair<Table, List<JoinSpec>> visit(NamedTableNode namedTableNode) throws SQLException { TableRef tableRef = resolveTable(namedTableNode.getAlias(), namedTableNode.getName()); boolean isWildCard = isWildCardSelectForTable(select.getSelect(), tableRef, origResolver); Table table = new Table(namedTableNode, isWildCard, namedTableNode.getDynamicColumns(), namedTableNode.getTableSamplingRate(), tableRef); return new Pair<Table, List<JoinSpec>>(table, null); }
@Override public void toSQL(ColumnResolver resolver, StringBuilder buf) { buf.append(this.getName().toString()); if (!dynColumns.isEmpty()) { buf.append('('); for (ColumnDef def : dynColumns) { buf.append(def); buf.append(','); } buf.setLength(buf.length()-1); buf.append(')'); } if (this.getAlias() != null) buf.append(" " + this.getAlias()); if (this.getTableSamplingRate() != null) buf.append(" TABLESAMPLE " + this.getTableSamplingRate()); buf.append(' '); }
@Override public void toSQL(ColumnResolver resolver, StringBuilder buf) { buf.append(this.getName().toString()); if (!dynColumns.isEmpty()) { buf.append('('); for (ColumnDef def : dynColumns) { buf.append(def); buf.append(','); } buf.setLength(buf.length()-1); buf.append(')'); } if (this.getAlias() != null) buf.append(" " + this.getAlias()); if (this.getTableSamplingRate() != null) buf.append(" TABLESAMPLE " + this.getTableSamplingRate()); buf.append(' '); }
@Override public TableNode visit(NamedTableNode namedTableNode) throws SQLException { TableRef tableRef = resolveTable(namedTableNode.getAlias(), namedTableNode.getName()); TableRef replaceRef = replacement.get(tableRef); if (replaceRef == null) return namedTableNode; String alias = namedTableNode.getAlias(); return FACTORY.namedTable(alias == null ? null : '"' + alias + '"', getReplacedTableName(replaceRef), namedTableNode.getDynamicColumns(), namedTableNode.getTableSamplingRate()); }
@Override public TableNode visit(NamedTableNode namedTableNode) throws SQLException { TableRef tableRef = resolveTable(namedTableNode.getAlias(), namedTableNode.getName()); TableRef replaceRef = replacement.get(tableRef); if (replaceRef == null) return namedTableNode; String alias = namedTableNode.getAlias(); return FACTORY.namedTable(alias == null ? null : '"' + alias + '"', getReplacedTableName(replaceRef), namedTableNode.getDynamicColumns(), namedTableNode.getTableSamplingRate()); }
@Override public Pair<Table, List<JoinSpec>> visit(NamedTableNode namedTableNode) throws SQLException { TableRef tableRef = resolveTable(namedTableNode.getAlias(), namedTableNode.getName()); boolean isWildCard = isWildCardSelectForTable(select.getSelect(), tableRef, origResolver); Table table = new Table(namedTableNode, isWildCard, namedTableNode.getDynamicColumns(), namedTableNode.getTableSamplingRate(), tableRef); return new Pair<Table, List<JoinSpec>>(table, null); }
@Override public Pair<Table, List<JoinSpec>> visit(NamedTableNode namedTableNode) throws SQLException { TableRef tableRef = resolveTable(namedTableNode.getAlias(), namedTableNode.getName()); boolean isWildCard = isWildCardSelectForTable(select.getSelect(), tableRef, origResolver); Table table = new Table(namedTableNode, isWildCard, namedTableNode.getDynamicColumns(), namedTableNode.getTableSamplingRate(), tableRef); return new Pair<Table, List<JoinSpec>>(table, null); }