How to query with doctrine dql the where in clause?

How do you take advantage of Hive bucketing in a SELECT query?

• I have a hive table bucketed on userId, My select query contains userId in where clause but hive is doing full table scan. `hive.enforce.bucketing` is true Why don't hive take advantage of bucketing in such cases, is there any config to enable it?? Table Structure userId int, name int, address String, cell int, ...... ...... ...... ...... CLUSTERED BY  (userId) SORTED BY (userId) INTO 20 BUCKETS Select query select cell from <table> where userId=<userId>

• Answer:

  How are you inserting data into this table? note that to take advantage of bucketing, you need to insert data using a hive query itself. If you manually put a text file at the location, bucketing wont work on that!