Hi ,
After I upgarte to 2.11 as you suggest to solve my order by issue. I start getting this exception it is complettly in different part of the application
the table is defined as follows.
create table medias_by_id(
   type TEXT,
   id UUID ,
   title TEXT,
   description TEXT,
   pic_320X320 TEXT,
   pic_100X100 TEXT,
   pic_large TEXT,
   image_category UUID,
   user_id UUID,
   created_date BIGINT,
   like_count INT ,
   share_count INT,
   dislike_count INT,
   comment_count INT,
   view_count INT,
   rating FLOAT,
   rating_total FLOAT,
   number_of_raring INT,   Â
   video_file_name text,
   PRIMARY KEY(id)
) ;
and this is the java model for that table
import javax.persistence.Column;
import javax.persistence.EmbeddedId;
import javax.persistence.Entity;
import
javax.persistence.Id;
import javax.persistence.Table;
import javax.xml.bind.annotation.XmlRootElement;
import com.audition.dao.model.key.ImagesByDateKey;
import com.impetus.kundera.index.IndexCollection;
import com.impetus.kundera.index.Index;
/**
 */
@Entity
@Table(name = "medias_by_id", schema = "auditionspace@auditionspace_pu")
//@IndexCollection(columns = { @Index(name = "created_by"), @Index(name = "image_category")})
@XmlRootElement(name = "imagesById")
public class ImagesById {
   @Id
   @Column(name="id")
   private UUID id ;
   @Column(name="type")
   private String type ;
   @Column(name="created_date")
   private long createdDate ;
   @Column(name="user_id")
   private UUID userId ;
   @Column(name="description")
   private String description ;
   @Column(name="pic_320x320")
   private String pic320X320 ;
   @Column(name="pic_100x100")
   private String pic100X100 ;
   @Column(name="pic_large")
   private String picLarge ;
   @Column(name="image_category")
   private UUID imageCategory ;
   @Column(name="like_count")
   private int likeCount ;
   @Column(name="share_count")
   private int shareCount ;
   @Column(name="dislike_count")
   private int dislikeCount ;
   @Column(name="rating")
   private float rating ;
   @Column(name="rating_total")
   private float raingTotal ;
   @Column(name="number_of_raring")
   private int numberOfRating ;
   @Column(name="title")
   private String title;
   @Column(name="comment_count")
   private int commentCount ;
   @Column(name="view_count")
   private int viewCount ;
   @Column(name="video_file_name")
   private String videoFileName;
  Â
   /**
    * Method getUserId.
    * @return UUID
    */
   public UUID getUserId() {
      return userId;
   }
   /**
    * Method setUserId.
    * @param userId UUID
    */
   public void setUserId(UUID userId) {
      this.userId = userId;
   }
   /**
    * Method getDescription.
    * @return String
    */
   public String getDescription() {
      return description;
   }
   /**
    * Method setDescription.
    * @param description String
    */
   public void setDescription(String description) {
      this.description = description;
   }
   /**
    * Method getPic320X320.
    * @return String
    */
   public String getPic320X320() {
      return pic320X320;
   }
   /**
    * Method setPic320X320.
    * @param pic320x320 String
    */
   public void setPic320X320(String pic320x320) {
      pic320X320 = pic320x320;
   }
   /**
    * Method getPic100X100.
    * @return String
    */
   public String getPic100X100() {
      return pic100X100;
   }
   /**
    * Method setPic100X100.
    * @param pic100x100 String
    */
   public void setPic100X100(String pic100x100) {
      pic100X100 = pic100x100;
   }
   /**
    * Method getPicLarge.
    * @return String
    */
   public String getPicLarge() {
      return picLarge;
   }
   /**
    * Method setPicLarge.
    * @param picLarge String
    */
   public void setPicLarge(String picLarge) {
      this.picLarge = picLarge;
   }
   /**
    * Method getImageCategory.
    * @return UUID
    */
   public UUID getImageCategory() {
      return imageCategory;
   }
   /**
    * Method setImageCategory.
    * @param imageCategory UUID
    */
   public void setImageCategory(UUID imageCategory) {
      this.imageCategory = imageCategory;
   }
   /**
    * Method getLikeCount.
    * @return int
    */
   public int getLikeCount() {
      return likeCount;
   }
   /**
    * Method setLikeCount.
    * @param likeCount int
    */
   public void setLikeCount(int likeCount) {
      this.likeCount = likeCount;
   }
   /**
    * Method getShareCount.
    * @return int
    */
   public int getShareCount() {
      return shareCount;
   }
   /**
    * Method setShareCount.
    * @param shareCount int
    */
   public void setShareCount(int shareCount) {
      this.shareCount = shareCount;
   }
   /**
    * Method getDislikeCount.
    * @return int
    */
   public int getDislikeCount() {
      return dislikeCount;
   }
   /**
    * Method setDislikeCount.
    * @param dislikeCount int
    */
   public void setDislikeCount(int dislikeCount) {
      this.dislikeCount = dislikeCount;
   }
   /**
    * Method getRating.
    * @return float
    */
   public float getRating() {
      return rating;
   }
   /**
    * Method setRating.
    * @param rating float
    */
   public void setRating(float rating) {
      this.rating = rating;
   }
   /**
    * Method getRaingTotal.
    * @return float
    */
   public float getRaingTotal() {
      return raingTotal;
   }
   /**
    * Method setRaingTotal.
    * @param raingTotal float
    */
   public void setRaingTotal(float raingTotal) {
      this.raingTotal = raingTotal;
   }
   /**
    * Method getNumberOfRating.
    * @return int
    */
   public int getNumberOfRating() {
      return numberOfRating;
   }
   /**
    * Method setNumberOfRating.
    * @param numberOfRating int
    */
   public void setNumberOfRating(int numberOfRating) {
      this.numberOfRating = numberOfRating;
   }
   /**
    * Method getTitle.
    * @return String
    */
   public String getTitle() {
      return title;
   }
   /**
    * Method setTitle.
    * @param title String
    */
   public void setTitle(String title) {
      this.title = title;
   }
   /**
    * Method getId.
    * @return UUID
    */
   public UUID getId() {
      return id;
   }
   /**
    * Method setId.
    * @param id UUID
    */
   public void setId(UUID id) {
     Â
this.id = id;
   }
   /**
    * Method getCommentCount.
    * @return int
    */
   public int getCommentCount() {
      return commentCount;
   }
   /**
    * Method setCommentCount.
    * @param commentCount int
    */
   public void setCommentCount(int commentCount) {
      this.commentCount = commentCount;
   }
   /**
    * Method getViewCount.
    * @return int
    */
   public int getViewCount() {
      return viewCount;
   }
   /**
    * Method setViewCount.
    * @param viewCount int
    */
   public void setViewCount(int viewCount) {
      this.viewCount = viewCount;
   }
   /**
    * Method getType.
    * @return String
    */
   public String getType() {
      return type;
   }
   /**
    * Method setType.
    * @param type String
    */
   public void setType(String type) {
      this.type = type;
   }
   /**
    * Method getCreatedDate.
    * @return long
    */
   public long getCreatedDate() {
      return createdDate;
   }
   /**
    * Method setCreatedDate.
    * @param createdDate long
    */
   public void setCreatedDate(long createdDate) {
      this.createdDate = createdDate;
   }
   /**
    * Method VideoFileName.
    * @return String
    */
   public String getVideoFileName() {
      return videoFileName;
   }
   /**
    * Method VideoFileName.
    * @param videoFileName String
    */
   public void setVideoFileName(String videoFileName) {
      this.videoFileName = videoFileName;
   }
}
and this is how I get the data based on the id
@Override
   public ImageDto getOneImageById(UUID id) {
      // TODO Auto-generated method stub
      String query = "SELECT images FROM " + ImagesById.class.getSimpleName()
            + " images WHERE
images.id= :id";
    Â
 List<ImagesById> ls = (List<ImagesById>) this.dao.findByQuery(query,
            "id", id);      if (ls != null && ls.size() > 0) {
         ImageDto dto = new ImageDto();
         dto = this.convertImagesByIdToImageDto(ls.get(0), dto);
         UserDto user = this.userBo.getUserById(dto.getUserId());
         String userFirstName = user.getFirstName();
         String userLastName = user.getLastName();
         MediaCategoriesDto category = this.imageCategorybo
               .getImageCategoryById(dto.getImageCategory());
         String categoryName = category.getCategoryDesc();
         dto.setCategoryName(categoryName);
         dto.setUserFirstName(userFirstName);
         dto.setUserLastName(userLastName);
         return dto;
      } else {
         return null;
      }
   }
the bold line is where my code is broking currently it was working fine in 2.9. (5b997526-5485-4ef9-94b2-f261daa53eea) is there in the table I can select it using CQLSH. I dont know what casuing this issue, any help will be highly appreciated.
[Request processing failed; nested exception is javax.persistence.PersistenceException: javax.persistence.PersistenceException: com.impetus.kundera.KunderaException: InvalidRequestException(why:Undefined name key in where clause ('key EQ token(5b997526-5485-4ef9-94b2-f261daa53eea)'))] with root cause
InvalidRequestException(why:Undefined name key in where clause ('key EQ token(5b997526-5485-4ef9-94b2-f261daa53eea)'))
   at org.apache.cassandra.thrift.Cassandra$execute_cql3_query_result.read(Cassandra.java:37849)
   at org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:78)
   at org.apache.cassandra.thrift.Cassandra$Client.recv_execute_cql3_query(Cassandra.java:1562)
   at org.apache.cassandra.thrift.Cassandra$Client.execute_cql3_query(Cassandra.java:1547)
   at com.impetus.client.cassandra.CassandraClientBase.execute(CassandraClientBase.java:2291)
   at com.impetus.client.cassandra.CassandraClientBase.executeCQLQuery(CassandraClientBase.java:1860)
   at com.impetus.client.cassandra.CassandraClientBase$CQLClient.executeQuery(CassandraClientBase.java:2028)
   at com.impetus.client.cassandra.CassandraClientBase.executeSelectQuery(CassandraClientBase.java:854)
   at com.impetus.client.cassandra.thrift.ThriftClient.executeQuery(ThriftClient.java:906)
   at com.impetus.client.cassandra.query.CassQuery.populateEntities(CassQuery.java:135)
   at com.impetus.kundera.query.QueryImpl.fetch(QueryImpl.java:927)
   at com.impetus.kundera.query.QueryImpl.getResultList(QueryImpl.java:157)
   at com.audition.dao.impl.AuditionDaoImpl.findByQuery(AuditionDaoImpl.java:143)
   at com.audition.bo.impl.ImageBoImpl.getOneImageById(ImageBoImpl.java:520)
   at com.audition.bo.impl.UserActivityBoImpl.getUserActivityByUserAndHisFriend(UserActivityBoImpl.java:111)