title: Hibernate Criteria Query to get specific columns
body: <p>I am using Criteria Query in my code. It always fires <code>select * from ...</code></p>
  
  <p>Instead I want to neglect one column(field) from my query as that field have large number of data stored in bytes. And that causing performance issue.</p>
  
  <p>Can any one give an idea for that?</p>
  
  <hr>
  
  <p><strong>Some Update</strong></p>
  
  <p>I added a projection in my query and it created a query like...</p>
  
  <pre><code>select
      this_.TEMPLATE_ID as y0_,
      this_.TEMPLATE_NAME as y1_,
      this_.CREATE_DATE as y2_,
      this_.UPDATE_DATE as y3_,
      this_.STATUS_CODE as y4_,
      this_.USER_ID as y5_,
      this_.UPDATED_BY as y6_,
      this_.CATEGORY_ID as y7_,
      this_.PRACTICE_ID as y8_ 
  from
      templates this_ 
  inner join
      user user1_ 
          on this_.USER_ID=user1_.USER_ID 
  inner join
      template_categories category2_ 
          on this_.CATEGORY_ID=category2_.CATEGORY_ID 
  where
      y4_=? 
      and y8_=? 
      and y5_ in (
          ?, ?
      ) 
  order by
      y1_ asc limit ?
  </code></pre>
  
  <p>And now issue is like.. <code>Unknown column 'y4_' in 'where clause'</code>
  and same error for y8_ , y5_ means for all where close it gave an error.</p>
  
  <p>I modified it to Query like ...</p>
  
  <pre><code>select
      this_.TEMPLATE_ID as y0_,
      this_.TEMPLATE_NAME as y1_,
      this_.CREATE_DATE as y2_,
      this_.UPDATE_DATE as y3_,
      this_.STATUS_CODE as y4_,
      this_.USER_ID as y5_,
      this_.UPDATED_BY as y6_,
      this_.CATEGORY_ID as y7_,
      this_.PRACTICE_ID as y8_ 
  from
      templates this_ 
  inner join
      user user1_ 
          on this_.USER_ID=user1_.USER_ID 
  inner join
      template_categories category2_ 
          on this_.CATEGORY_ID=category2_.CATEGORY_ID 
  where
      this_.STATUS_CODE=1
      and this_.PRACTICE_ID=1 
      and this_.USER_ID in (
          1, 2
      ) 
  order by
      y1_ asc limit ?
  </code></pre>
  
  <p>and it worked. But I don't know how to modify it in HQL?</p>