@Override protected Void visitCreateSchema(CreateSchema node, Integer context) { builder.append("CREATE SCHEMA "); if (node.isNotExists()) { builder.append("IF NOT EXISTS "); } builder.append(formatName(node.getSchemaName())); builder.append(formatPropertiesMultiLine(node.getProperties())); return null; }
@Override protected Void visitCreateSchema(CreateSchema node, Integer context) { builder.append("CREATE SCHEMA "); if (node.isNotExists()) { builder.append("IF NOT EXISTS "); } builder.append(formatName(node.getSchemaName())); builder.append(formatPropertiesMultiLine(node.getProperties())); return null; }
@Override protected Void visitCreateTableAsSelect(CreateTableAsSelect node, Integer indent) { builder.append("CREATE TABLE "); if (node.isNotExists()) { builder.append("IF NOT EXISTS "); } builder.append(formatName(node.getName())); if (node.getColumnAliases().isPresent()) { String columnList = node.getColumnAliases().get().stream().map(element -> formatExpression(element, parameters)).collect(joining(", ")); builder.append(format("( %s )", columnList)); } if (node.getComment().isPresent()) { builder.append("\nCOMMENT " + formatStringLiteral(node.getComment().get())); } builder.append(formatPropertiesMultiLine(node.getProperties())); builder.append(" AS "); process(node.getQuery(), indent); if (!node.isWithData()) { builder.append(" WITH NO DATA"); } return null; }
builder.append(formatPropertiesMultiLine(node.getProperties()));
builder.append(formatPropertiesMultiLine(node.getProperties()));
@Override protected Void visitCreateTableAsSelect(CreateTableAsSelect node, Integer indent) { builder.append("CREATE TABLE "); if (node.isNotExists()) { builder.append("IF NOT EXISTS "); } builder.append(formatName(node.getName())); if (node.getColumnAliases().isPresent()) { String columnList = node.getColumnAliases().get().stream().map(element -> formatExpression(element, parameters)).collect(joining(", ")); builder.append(format("( %s )", columnList)); } if (node.getComment().isPresent()) { builder.append("\nCOMMENT " + formatStringLiteral(node.getComment().get())); } builder.append(formatPropertiesMultiLine(node.getProperties())); builder.append(" AS "); process(node.getQuery(), indent); if (!node.isWithData()) { builder.append(" WITH NO DATA"); } return null; }
@Override protected Void visitAnalyze(Analyze node, Integer context) { builder.append("ANALYZE ") .append(formatName(node.getTableName())); builder.append(formatPropertiesMultiLine(node.getProperties())); return null; }
@Override protected Void visitAnalyze(Analyze node, Integer context) { builder.append("ANALYZE ") .append(formatName(node.getTableName())); builder.append(formatPropertiesMultiLine(node.getProperties())); return null; }