[jira] [Created] (CARBONDATA-1887) block pruning not happening is carbon for ShortType and SmallIntType columns

[Akash R Nilugal (Jira)]

Mohammad Shahid Khan created CARBONDATA-1887:
------------------------------------------------

             Summary: block pruning not happening is carbon for ShortType and SmallIntType columns
                 Key: CARBONDATA-1887
                 URL: https://issues.apache.org/jira/browse/CARBONDATA-1887
             Project: CarbonData
          Issue Type: Bug
            Reporter: Mohammad Shahid Khan
            Assignee: Mohammad Shahid Khan




spark.sql(
      s"""
         | create table test_numeric_type(c1 int, c2 long, c3 smallint, c4 bigint, c5 short) stored by 'carbondata'
       """.stripMargin).show()
    spark.sql(
      s"""
         | insert into test_numeric_type select 1,1111111,111,1111111111,'2019-01-03 12:12:12'
       """.stripMargin).show()

    spark.sql(
      s"""
         | insert into test_numeric_type select 2,2222222,222,2222222222,'2020-01-03 12:12:12'
       """.stripMargin).show()

    spark.sql(
      s"""
         | insert into test_numeric_type select 3,3333333,333,3333333333,'2021-01-03 12:12:12'
       """.stripMargin).show()

    spark.sql(
      s"""
         | select * from test_numeric_type where c5>1111
       """.stripMargin).show()

Only two blocks should be selected but all blocks are selected during query execution.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)