本文整理了Java中io.prestosql.sql.QueryUtil.query
方法的一些代码示例,展示了QueryUtil.query
的具体用法。这些代码示例主要来源于Github
/Stackoverflow
/Maven
等平台,是从一些精选项目中提取出来的代码,具有较强的参考意义,能在一定程度帮忙到你。QueryUtil.query
方法的具体详情如下:
包路径:io.prestosql.sql.QueryUtil
类名称:QueryUtil
方法名:query
暂无
代码示例来源:origin: io.prestosql/presto-parser
public static Query simpleQuery(Select select, Relation from, Optional<Expression> where, Optional<GroupBy> groupBy, Optional<Expression> having, Optional<OrderBy> orderBy, Optional<String> limit)
{
return query(new QuerySpecification(
select,
Optional.of(from),
where,
groupBy,
having,
orderBy,
limit));
}
代码示例来源:origin: io.prestosql/presto-parser
public static Query simpleQuery(Select select)
{
return query(new QuerySpecification(
select,
Optional.empty(),
Optional.empty(),
Optional.empty(),
Optional.empty(),
Optional.empty(),
Optional.empty()));
}
代码示例来源:origin: prestosql/presto
public static Query simpleQuery(Select select)
{
return query(new QuerySpecification(
select,
Optional.empty(),
Optional.empty(),
Optional.empty(),
Optional.empty(),
Optional.empty(),
Optional.empty()));
}
代码示例来源:origin: prestosql/presto
public static Query simpleQuery(Select select, Relation from, Optional<Expression> where, Optional<GroupBy> groupBy, Optional<Expression> having, Optional<OrderBy> orderBy, Optional<String> limit)
{
return query(new QuerySpecification(
select,
Optional.of(from),
where,
groupBy,
having,
orderBy,
limit));
}
代码示例来源:origin: prestosql/presto
@Test
public void testLimitAll()
{
Query valuesQuery = query(values(
row(new LongLiteral("1"), new StringLiteral("1")),
row(new LongLiteral("2"), new StringLiteral("2"))));
assertStatement("SELECT * FROM (VALUES (1, '1'), (2, '2')) LIMIT ALL",
simpleQuery(selectList(new AllColumns()),
subquery(valuesQuery),
Optional.empty(),
Optional.empty(),
Optional.empty(),
Optional.empty(),
Optional.of("ALL")));
}
代码示例来源:origin: prestosql/presto
query(new Values(ImmutableList.of(new LongLiteral("1")))),
Optional.of(ImmutableList.of(identifier("x"))))))),
new Table(QualifiedName.of("t")),
代码示例来源:origin: prestosql/presto
@Test
public void testValues()
{
Query valuesQuery = query(values(
row(new StringLiteral("a"), new LongLiteral("1"), new DoubleLiteral("2.2")),
row(new StringLiteral("b"), new LongLiteral("2"), new DoubleLiteral("3.3"))));
assertStatement("VALUES ('a', 1, 2.2e0), ('b', 2, 3.3e0)", valuesQuery);
assertStatement("SELECT * FROM (VALUES ('a', 1, 2.2e0), ('b', 2, 3.3e0))",
simpleQuery(
selectList(new AllColumns()),
subquery(valuesQuery)));
}
代码示例来源:origin: prestosql/presto
@Test
public void testQuantifiedComparison()
{
assertExpression("col1 < ANY (SELECT col2 FROM table1)",
new QuantifiedComparisonExpression(
LESS_THAN,
QuantifiedComparisonExpression.Quantifier.ANY,
identifier("col1"),
new SubqueryExpression(simpleQuery(selectList(new SingleColumn(identifier("col2"))), table(QualifiedName.of("table1"))))));
assertExpression("col1 = ALL (VALUES ROW(1), ROW(2))",
new QuantifiedComparisonExpression(
ComparisonExpression.Operator.EQUAL,
QuantifiedComparisonExpression.Quantifier.ALL,
identifier("col1"),
new SubqueryExpression(query(values(row(new LongLiteral("1")), row(new LongLiteral("2")))))));
assertExpression("col1 >= SOME (SELECT 10)",
new QuantifiedComparisonExpression(
ComparisonExpression.Operator.GREATER_THAN_OR_EQUAL,
QuantifiedComparisonExpression.Quantifier.SOME,
identifier("col1"),
new SubqueryExpression(simpleQuery(selectList(new LongLiteral("10"))))));
}
内容来源于网络,如有侵权,请联系作者删除!