carbondata-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "kumar vishal (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (CARBONDATA-1887) block pruning not happening is carbon for ShortType and SmallIntType columns
Date Thu, 14 Dec 2017 13:50:00 GMT

     [ https://issues.apache.org/jira/browse/CARBONDATA-1887?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

kumar vishal resolved CARBONDATA-1887.
--------------------------------------
       Resolution: Fixed
    Fix Version/s: 1.3.0

> 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
>             Fix For: 1.3.0
>
>          Time Spent: 4h 20m
>  Remaining Estimate: 0h
>
> 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)

Mime
View raw message