Introducing the all-new TIBCO Community site!

For current users, please click "Sign In" to reset your password and access the enhanced features. If you're a first-time visitor, we extend a warm welcome—click "Sign Up" to become a part of the TIBCO Community!

If you're seeking alternative community sites, explore ibi, Jaspersoft, and Spotfire.

Jump to content

"All rows" in Query Operator on Ordered Primary Index of Query Table with duplicates on the index field returns only one row


Sharad Honavar

Recommended Posts

I have aQuery Table which I populated from a simple csv(see example below). In Query Tabledefinition, I have a Ordered (btree) Primary Index(int) on a field which has duplicate datarows for the field. I also have a Secondary (btree) Index on another field. Now in the Query OperatorI do a READ operation

"Where": "All Rows" ;

"Order By" : "Primary Index", "Ascending";

"Limit" 100

But a run returns only one record for each unique Primary key for the higest Secondary index value of all duplicate index values of the Primary INdex.

QUESTIONS:

1) So The "All Rows" is not what it says in the Query Operator doc page:"Selects all rows, independent of keys."

2) Will the WRITE enforce Uniqueness of the Primary keys defined by the Primary Index

 

 

 

 

Example

fld1(Primary), fld2(Secondary), fld3

3, 4, alpha

3,4, beta

3, 5, gamma

5,1, theta

5,2, delta

5,4, omega

READ All Rows returns (3,5, gamma) and (5,4,omega)

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...