Re: SARG predicate is ignored when query ORC table

Hi, Mich, Thanks for the reply. We don't set any tblproperties when creating table. Here is the TBLPROPERTIES part from show create table: STORED AS ORC TBLPROPERTIES ('transient_lastDdlTime'='1455765074') Jessica On Sat, Feb 27, 2016 at 11:15 AM, Mich Talebzadeh wrote: > Hi, > > Can you do

Re: SARG predicate is ignored when query ORC table

Hi, Can you do show create table on your external table and send the sections from STORED AS ORC TBLPROPERTIES ( onwards please? HTH Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw

SARG predicate is ignored when query ORC table

Hi, We have an external ORC table which includes ~200 relatively small orc files (less than 256MB). When querying the table with selective SARG predicate (explain shows the predicate is qualified pushdown), we expects a few splits generated with pruning based on predicate condition and only a few

Re: Running hive queries in different queue

Hello. What Hive client are you using? beeline Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw * http://talebzadehmich.wordpress.com On 27 Feb