Hi Aaron, Thanks for reporting issue. Can you help me narrow down the issue? as I cannot reproduce locally with the information given in your mail.
a) First can you disable local dictionary and try the same scenario? b) Can drop datamp and try the same scenario? -- If data is coming from data map (can see this in explain command) c) Avoid compaction and try the same scenario. d) If you can share, give me test data and complete steps. (Because compaction and other steps are not there in your previous mail) Mean while, I will try to reproduce locally again but I don't have complete steps you executed. Thanks, Ajantha On Wed, Sep 26, 2018 at 9:17 PM aaron <[email protected]> wrote: > Hi Community, > > It seems that rows disappeared, same query get different result > > carbon.time(carbon.sql( > s""" > |EXPLAIN SELECT date, market_code, device_code, country_code, > category_id, product_id, est_free_app_download, est_paid_app_download, > est_revenue > |FROM store > |WHERE date = '2016-09-01' AND device_code='ios-phone' AND > country_code='EE' AND product_id IN (590416158, 590437560)""" > .stripMargin).show(truncate=false) > ) > > > Screen_Shot_2018-09-26_at_11.png > < > http://apache-carbondata-dev-mailing-list-archive.1130556.n5.nabble.com/file/t357/Screen_Shot_2018-09-26_at_11.png> > > Screen_Shot_2018-09-26_at_11.png > < > http://apache-carbondata-dev-mailing-list-archive.1130556.n5.nabble.com/file/t357/Screen_Shot_2018-09-26_at_11.png> > > > > > -- > Sent from: > http://apache-carbondata-dev-mailing-list-archive.1130556.n5.nabble.com/ >
