io.prestosql.spi.predicate.Range.lessThan()方法的使用及代码示例

x33g5p2x  于2022-01-29 转载在 其他  
字(13.3k)|赞(0)|评价(0)|浏览(236)

本文整理了Java中io.prestosql.spi.predicate.Range.lessThan方法的一些代码示例，展示了Range.lessThan的具体用法。这些代码示例主要来源于Github/Stackoverflow/Maven等平台，是从一些精选项目中提取出来的代码，具有较强的参考意义，能在一定程度帮忙到你。Range.lessThan方法的具体详情如下：
包路径：io.prestosql.spi.predicate.Range
类名称：Range
方法名：lessThan

Range.lessThan介绍

暂无

代码示例

代码示例来源：origin: io.prestosql/presto-spi

  1. @Test
  2. public void testGetSingleValue()
  3. {
  4.   assertEquals(Range.equal(BIGINT, 0L).getSingleValue(), 0L);
  5.   try {
  6.     Range.lessThan(BIGINT, 0L).getSingleValue();
  7.     fail();
  8.   }
  9.   catch (IllegalStateException e) {
  10.   }
  11. }

代码示例来源：origin: io.prestosql/presto-spi

  1. @Test
  2. public void testSpan()
  3. {
  4.   assertEquals(Range.greaterThan(BIGINT, 1L).span(Range.lessThanOrEqual(BIGINT, 2L)), Range.all(BIGINT));
  5.   assertEquals(Range.greaterThan(BIGINT, 2L).span(Range.lessThanOrEqual(BIGINT, 0L)), Range.all(BIGINT));
  6.   assertEquals(Range.range(BIGINT, 1L, true, 3L, false).span(Range.equal(BIGINT, 2L)), Range.range(BIGINT, 1L, true, 3L, false));
  7.   assertEquals(Range.range(BIGINT, 1L, true, 3L, false).span(Range.range(BIGINT, 2L, false, 10L, false)), Range.range(BIGINT, 1L, true, 10L, false));
  8.   assertEquals(Range.greaterThan(BIGINT, 1L).span(Range.equal(BIGINT, 0L)), Range.greaterThanOrEqual(BIGINT, 0L));
  9.   assertEquals(Range.greaterThan(BIGINT, 1L).span(Range.greaterThanOrEqual(BIGINT, 10L)), Range.greaterThan(BIGINT, 1L));
  10.   assertEquals(Range.lessThan(BIGINT, 1L).span(Range.lessThanOrEqual(BIGINT, 1L)), Range.lessThanOrEqual(BIGINT, 1L));
  11.   assertEquals(Range.all(BIGINT).span(Range.lessThanOrEqual(BIGINT, 1L)), Range.all(BIGINT));
  12. }

代码示例来源：origin: prestosql/presto

  1. @Test
  2. public void testSpan()
  3. {
  4.   assertEquals(Range.greaterThan(BIGINT, 1L).span(Range.lessThanOrEqual(BIGINT, 2L)), Range.all(BIGINT));
  5.   assertEquals(Range.greaterThan(BIGINT, 2L).span(Range.lessThanOrEqual(BIGINT, 0L)), Range.all(BIGINT));
  6.   assertEquals(Range.range(BIGINT, 1L, true, 3L, false).span(Range.equal(BIGINT, 2L)), Range.range(BIGINT, 1L, true, 3L, false));
  7.   assertEquals(Range.range(BIGINT, 1L, true, 3L, false).span(Range.range(BIGINT, 2L, false, 10L, false)), Range.range(BIGINT, 1L, true, 10L, false));
  8.   assertEquals(Range.greaterThan(BIGINT, 1L).span(Range.equal(BIGINT, 0L)), Range.greaterThanOrEqual(BIGINT, 0L));
  9.   assertEquals(Range.greaterThan(BIGINT, 1L).span(Range.greaterThanOrEqual(BIGINT, 10L)), Range.greaterThan(BIGINT, 1L));
  10.   assertEquals(Range.lessThan(BIGINT, 1L).span(Range.lessThanOrEqual(BIGINT, 1L)), Range.lessThanOrEqual(BIGINT, 1L));
  11.   assertEquals(Range.all(BIGINT).span(Range.lessThanOrEqual(BIGINT, 1L)), Range.all(BIGINT));
  12. }

代码示例来源：origin: prestosql/presto

  1. @Test
  2. public void testGetSingleValue()
  3. {
  4.   assertEquals(Range.equal(BIGINT, 0L).getSingleValue(), 0L);
  5.   try {
  6.     Range.lessThan(BIGINT, 0L).getSingleValue();
  7.     fail();
  8.   }
  9.   catch (IllegalStateException e) {
  10.   }
  11. }

代码示例来源：origin: io.prestosql/presto-spi

  1. @Test
  2. public void testOverlaps()
  3. {
  4.   assertTrue(Range.greaterThan(BIGINT, 1L).overlaps(Range.lessThanOrEqual(BIGINT, 2L)));
  5.   assertFalse(Range.greaterThan(BIGINT, 2L).overlaps(Range.lessThan(BIGINT, 2L)));
  6.   assertTrue(Range.range(BIGINT, 1L, true, 3L, false).overlaps(Range.equal(BIGINT, 2L)));
  7.   assertTrue(Range.range(BIGINT, 1L, true, 3L, false).overlaps(Range.range(BIGINT, 2L, false, 10L, false)));
  8.   assertFalse(Range.range(BIGINT, 1L, true, 3L, false).overlaps(Range.range(BIGINT, 3L, true, 10L, false)));
  9.   assertTrue(Range.range(BIGINT, 1L, true, 3L, true).overlaps(Range.range(BIGINT, 3L, true, 10L, false)));
  10.   assertTrue(Range.all(BIGINT).overlaps(Range.equal(BIGINT, Long.MAX_VALUE)));
  11. }

代码示例来源：origin: prestosql/presto

  1. @Test
  2. public void testBuildQueryOr()
  3. {
  4.   TupleDomain<ColumnHandle> tupleDomain = TupleDomain.withColumnDomains(ImmutableMap.of(
  5.       COL1, Domain.create(ValueSet.ofRanges(lessThan(BIGINT, 100L), greaterThan(BIGINT, 200L)), false)));
  6.   Document query = MongoSession.buildQuery(tupleDomain);
  7.   Document expected = new Document("$or", asList(
  8.       new Document(COL1.getName(), new Document("$lt", 100L)),
  9.       new Document(COL1.getName(), new Document("$gt", 200L))));
  10.   assertEquals(query, expected);
  11. }

代码示例来源：origin: prestosql/presto

  1. @Test
  2. public void testOverlaps()
  3. {
  4.   assertTrue(Range.greaterThan(BIGINT, 1L).overlaps(Range.lessThanOrEqual(BIGINT, 2L)));
  5.   assertFalse(Range.greaterThan(BIGINT, 2L).overlaps(Range.lessThan(BIGINT, 2L)));
  6.   assertTrue(Range.range(BIGINT, 1L, true, 3L, false).overlaps(Range.equal(BIGINT, 2L)));
  7.   assertTrue(Range.range(BIGINT, 1L, true, 3L, false).overlaps(Range.range(BIGINT, 2L, false, 10L, false)));
  8.   assertFalse(Range.range(BIGINT, 1L, true, 3L, false).overlaps(Range.range(BIGINT, 3L, true, 10L, false)));
  9.   assertTrue(Range.range(BIGINT, 1L, true, 3L, true).overlaps(Range.range(BIGINT, 3L, true, 10L, false)));
  10.   assertTrue(Range.all(BIGINT).overlaps(Range.equal(BIGINT, Long.MAX_VALUE)));
  11. }

代码示例来源：origin: io.prestosql/presto-spi

  1. @Test
  2. public void testExceptionalIntersect()
  3. {
  4.   try {
  5.     Range.greaterThan(BIGINT, 2L).intersect(Range.lessThan(BIGINT, 2L));
  6.     fail();
  7.   }
  8.   catch (IllegalArgumentException e) {
  9.   }
  10.   try {
  11.     Range.range(BIGINT, 1L, true, 3L, false).intersect(Range.range(BIGINT, 3L, true, 10L, false));
  12.     fail();
  13.   }
  14.   catch (IllegalArgumentException e) {
  15.   }
  16. }

代码示例来源：origin: prestosql/presto

  1. @Test
  2. public void testExceptionalIntersect()
  3. {
  4.   try {
  5.     Range.greaterThan(BIGINT, 2L).intersect(Range.lessThan(BIGINT, 2L));
  6.     fail();
  7.   }
  8.   catch (IllegalArgumentException e) {
  9.   }
  10.   try {
  11.     Range.range(BIGINT, 1L, true, 3L, false).intersect(Range.range(BIGINT, 3L, true, 10L, false));
  12.     fail();
  13.   }
  14.   catch (IllegalArgumentException e) {
  15.   }
  16. }

代码示例来源：origin: prestosql/presto

  1. @Test
  2. public void testLessThanRange()
  3. {
  4.   Range range = Range.lessThan(BIGINT, 1L);
  5.   assertEquals(range.getLow(), Marker.lowerUnbounded(BIGINT));
  6.   assertEquals(range.getHigh(), Marker.below(BIGINT, 1L));
  7.   assertFalse(range.isSingleValue());
  8.   assertFalse(range.isAll());
  9.   assertEquals(range.getType(), BIGINT);
  10.   assertTrue(range.includes(Marker.lowerUnbounded(BIGINT)));
  11.   assertFalse(range.includes(Marker.exactly(BIGINT, 1L)));
  12.   assertTrue(range.includes(Marker.exactly(BIGINT, 0L)));
  13.   assertFalse(range.includes(Marker.upperUnbounded(BIGINT)));
  14. }

代码示例来源：origin: io.prestosql/presto-spi

  1. @Test
  2. public void testLessThanRange()
  3. {
  4.   Range range = Range.lessThan(BIGINT, 1L);
  5.   assertEquals(range.getLow(), Marker.lowerUnbounded(BIGINT));
  6.   assertEquals(range.getHigh(), Marker.below(BIGINT, 1L));
  7.   assertFalse(range.isSingleValue());
  8.   assertFalse(range.isAll());
  9.   assertEquals(range.getType(), BIGINT);
  10.   assertTrue(range.includes(Marker.lowerUnbounded(BIGINT)));
  11.   assertFalse(range.includes(Marker.exactly(BIGINT, 1L)));
  12.   assertTrue(range.includes(Marker.exactly(BIGINT, 0L)));
  13.   assertFalse(range.includes(Marker.upperUnbounded(BIGINT)));
  14. }

代码示例来源：origin: io.prestosql/presto-spi

  1. @Test
  2. public void testSingleValue()
  3. {
  4.   SortedRangeSet rangeSet = SortedRangeSet.of(BIGINT, 10L);
  5.   SortedRangeSet complement = SortedRangeSet.of(Range.greaterThan(BIGINT, 10L), Range.lessThan(BIGINT, 10L));
  6.   assertEquals(rangeSet.getType(), BIGINT);
  7.   assertFalse(rangeSet.isNone());
  8.   assertFalse(rangeSet.isAll());
  9.   assertTrue(rangeSet.isSingleValue());
  10.   assertTrue(Iterables.elementsEqual(rangeSet.getOrderedRanges(), ImmutableList.of(Range.equal(BIGINT, 10L))));
  11.   assertEquals(rangeSet.getRangeCount(), 1);
  12.   assertEquals(rangeSet.complement(), complement);
  13.   assertFalse(rangeSet.includesMarker(Marker.lowerUnbounded(BIGINT)));
  14.   assertTrue(rangeSet.includesMarker(Marker.exactly(BIGINT, 10L)));
  15.   assertFalse(rangeSet.includesMarker(Marker.exactly(BIGINT, 9L)));
  16.   assertFalse(rangeSet.includesMarker(Marker.upperUnbounded(BIGINT)));
  17. }

代码示例来源：origin: io.prestosql/presto-hive

  1. @Test
  2.   public void testNotPushDoublePredicates()
  3.   {
  4.     IonSqlQueryBuilder queryBuilder = new IonSqlQueryBuilder(new TypeRegistry());
  5.     List<HiveColumnHandle> columns = ImmutableList.of(
  6.         new HiveColumnHandle("quantity", HIVE_INT, parseTypeSignature(INTEGER), 0, REGULAR, Optional.empty()),
  7.         new HiveColumnHandle("extendedprice", HIVE_DOUBLE, parseTypeSignature(StandardTypes.DOUBLE), 1, REGULAR, Optional.empty()),
  8.         new HiveColumnHandle("discount", HIVE_DOUBLE, parseTypeSignature(StandardTypes.DOUBLE), 2, REGULAR, Optional.empty()));
  9.     TupleDomain<HiveColumnHandle> tupleDomain = withColumnDomains(
  10.         ImmutableMap.of(
  11.             columns.get(0), Domain.create(ofRanges(Range.lessThan(BIGINT, 50L)), false),
  12.             columns.get(1), Domain.create(ofRanges(Range.equal(DOUBLE, 0.05)), false),
  13.             columns.get(2), Domain.create(ofRanges(Range.range(DOUBLE, 0.0, true, 0.02, true)), false)));
  14.     assertEquals("SELECT s._1, s._2, s._3 FROM S3Object s WHERE ((case s._1 when '' then null else CAST(s._1 AS INT) end < 50))",
  15.         queryBuilder.buildSql(columns, tupleDomain));
  16.   }
  17. }

代码示例来源：origin: prestosql/presto

  1. @Test
  2.   public void testNotPushDoublePredicates()
  3.   {
  4.     IonSqlQueryBuilder queryBuilder = new IonSqlQueryBuilder(new TypeRegistry());
  5.     List<HiveColumnHandle> columns = ImmutableList.of(
  6.         new HiveColumnHandle("quantity", HIVE_INT, parseTypeSignature(INTEGER), 0, REGULAR, Optional.empty()),
  7.         new HiveColumnHandle("extendedprice", HIVE_DOUBLE, parseTypeSignature(StandardTypes.DOUBLE), 1, REGULAR, Optional.empty()),
  8.         new HiveColumnHandle("discount", HIVE_DOUBLE, parseTypeSignature(StandardTypes.DOUBLE), 2, REGULAR, Optional.empty()));
  9.     TupleDomain<HiveColumnHandle> tupleDomain = withColumnDomains(
  10.         ImmutableMap.of(
  11.             columns.get(0), Domain.create(ofRanges(Range.lessThan(BIGINT, 50L)), false),
  12.             columns.get(1), Domain.create(ofRanges(Range.equal(DOUBLE, 0.05)), false),
  13.             columns.get(2), Domain.create(ofRanges(Range.range(DOUBLE, 0.0, true, 0.02, true)), false)));
  14.     assertEquals("SELECT s._1, s._2, s._3 FROM S3Object s WHERE ((case s._1 when '' then null else CAST(s._1 AS INT) end < 50))",
  15.         queryBuilder.buildSql(columns, tupleDomain));
  16.   }
  17. }

代码示例来源：origin: io.prestosql/presto-spi

  1. @Test
  2. public void testSpan()
  3. {
  4.   try {
  5.     SortedRangeSet.none(BIGINT).getSpan();
  6.     fail();
  7.   }
  8.   catch (IllegalStateException e) {
  9.   }
  10.   assertEquals(SortedRangeSet.all(BIGINT).getSpan(), Range.all(BIGINT));
  11.   assertEquals(SortedRangeSet.of(BIGINT, 0L).getSpan(), Range.equal(BIGINT, 0L));
  12.   assertEquals(SortedRangeSet.of(Range.equal(BIGINT, 0L), Range.equal(BIGINT, 1L)).getSpan(), Range.range(BIGINT, 0L, true, 1L, true));
  13.   assertEquals(SortedRangeSet.of(Range.equal(BIGINT, 0L), Range.greaterThan(BIGINT, 1L)).getSpan(), Range.greaterThanOrEqual(BIGINT, 0L));
  14.   assertEquals(SortedRangeSet.of(Range.lessThan(BIGINT, 0L), Range.greaterThan(BIGINT, 1L)).getSpan(), Range.all(BIGINT));
  15. }

代码示例来源：origin: prestosql/presto

  1. @Test
  2. public void testContains()
  3. {
  4.   assertTrue(Range.all(BIGINT).contains(Range.all(BIGINT)));
  5.   assertTrue(Range.all(BIGINT).contains(Range.equal(BIGINT, 0L)));
  6.   assertTrue(Range.all(BIGINT).contains(Range.greaterThan(BIGINT, 0L)));
  7.   assertTrue(Range.equal(BIGINT, 0L).contains(Range.equal(BIGINT, 0L)));
  8.   assertFalse(Range.equal(BIGINT, 0L).contains(Range.greaterThan(BIGINT, 0L)));
  9.   assertFalse(Range.equal(BIGINT, 0L).contains(Range.greaterThanOrEqual(BIGINT, 0L)));
  10.   assertFalse(Range.equal(BIGINT, 0L).contains(Range.all(BIGINT)));
  11.   assertTrue(Range.greaterThanOrEqual(BIGINT, 0L).contains(Range.greaterThan(BIGINT, 0L)));
  12.   assertTrue(Range.greaterThan(BIGINT, 0L).contains(Range.greaterThan(BIGINT, 1L)));
  13.   assertFalse(Range.greaterThan(BIGINT, 0L).contains(Range.lessThan(BIGINT, 0L)));
  14.   assertTrue(Range.range(BIGINT, 0L, true, 2L, true).contains(Range.range(BIGINT, 1L, true, 2L, true)));
  15.   assertFalse(Range.range(BIGINT, 0L, true, 2L, true).contains(Range.range(BIGINT, 1L, true, 3L, false)));
  16. }

代码示例来源：origin: prestosql/presto

  1. @Test
  2. public void testSpan()
  3. {
  4.   try {
  5.     SortedRangeSet.none(BIGINT).getSpan();
  6.     fail();
  7.   }
  8.   catch (IllegalStateException e) {
  9.   }
  10.   assertEquals(SortedRangeSet.all(BIGINT).getSpan(), Range.all(BIGINT));
  11.   assertEquals(SortedRangeSet.of(BIGINT, 0L).getSpan(), Range.equal(BIGINT, 0L));
  12.   assertEquals(SortedRangeSet.of(Range.equal(BIGINT, 0L), Range.equal(BIGINT, 1L)).getSpan(), Range.range(BIGINT, 0L, true, 1L, true));
  13.   assertEquals(SortedRangeSet.of(Range.equal(BIGINT, 0L), Range.greaterThan(BIGINT, 1L)).getSpan(), Range.greaterThanOrEqual(BIGINT, 0L));
  14.   assertEquals(SortedRangeSet.of(Range.lessThan(BIGINT, 0L), Range.greaterThan(BIGINT, 1L)).getSpan(), Range.all(BIGINT));
  15. }

代码示例来源：origin: io.prestosql/presto-spi

  1. @Test
  2. public void testContains()
  3. {
  4.   assertTrue(Range.all(BIGINT).contains(Range.all(BIGINT)));
  5.   assertTrue(Range.all(BIGINT).contains(Range.equal(BIGINT, 0L)));
  6.   assertTrue(Range.all(BIGINT).contains(Range.greaterThan(BIGINT, 0L)));
  7.   assertTrue(Range.equal(BIGINT, 0L).contains(Range.equal(BIGINT, 0L)));
  8.   assertFalse(Range.equal(BIGINT, 0L).contains(Range.greaterThan(BIGINT, 0L)));
  9.   assertFalse(Range.equal(BIGINT, 0L).contains(Range.greaterThanOrEqual(BIGINT, 0L)));
  10.   assertFalse(Range.equal(BIGINT, 0L).contains(Range.all(BIGINT)));
  11.   assertTrue(Range.greaterThanOrEqual(BIGINT, 0L).contains(Range.greaterThan(BIGINT, 0L)));
  12.   assertTrue(Range.greaterThan(BIGINT, 0L).contains(Range.greaterThan(BIGINT, 1L)));
  13.   assertFalse(Range.greaterThan(BIGINT, 0L).contains(Range.lessThan(BIGINT, 0L)));
  14.   assertTrue(Range.range(BIGINT, 0L, true, 2L, true).contains(Range.range(BIGINT, 1L, true, 2L, true)));
  15.   assertFalse(Range.range(BIGINT, 0L, true, 2L, true).contains(Range.range(BIGINT, 1L, true, 3L, false)));
  16. }

代码示例来源：origin: prestosql/presto

  1. @Test
  2. public void testFromNotPredicate()
  3. {
  4.   assertUnsupportedPredicate(not(and(equal(C_BIGINT, bigintLiteral(1L)), unprocessableExpression1(C_BIGINT))));
  5.   assertUnsupportedPredicate(not(unprocessableExpression1(C_BIGINT)));
  6.   assertPredicateIsAlwaysFalse(not(TRUE_LITERAL));
  7.   assertPredicateTranslates(
  8.       not(equal(C_BIGINT, bigintLiteral(1L))),
  9.       withColumnDomains(ImmutableMap.of(C_BIGINT, Domain.create(ValueSet.ofRanges(Range.lessThan(BIGINT, 1L), Range.greaterThan(BIGINT, 1L)), false))));
  10. }

代码示例来源：origin: io.prestosql/presto-main

  1. @Test
  2. public void testFromNotPredicate()
  3. {
  4.   assertUnsupportedPredicate(not(and(equal(C_BIGINT, bigintLiteral(1L)), unprocessableExpression1(C_BIGINT))));
  5.   assertUnsupportedPredicate(not(unprocessableExpression1(C_BIGINT)));
  6.   assertPredicateIsAlwaysFalse(not(TRUE_LITERAL));
  7.   assertPredicateTranslates(
  8.       not(equal(C_BIGINT, bigintLiteral(1L))),
  9.       withColumnDomains(ImmutableMap.of(C_BIGINT, Domain.create(ValueSet.ofRanges(Range.lessThan(BIGINT, 1L), Range.greaterThan(BIGINT, 1L)), false))));
  10. }

内容来源于网络，如有侵权，请联系作者删除！

range

相关文章

    查看更多

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新文章

    更多
    • 蜀ICP备13028337号-1 大数据知识库 https://www.saoniuhuo.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com