ERROR 122 (HY000): IDB-9029: Window function are only supported for InfiniDB tables.

2 posts / 0 new
Last post
bharath
bharath's picture
Offline
Last seen: 1 month 11 hours ago
Joined: Jun 24 2014
Junior Boarder

Posts: 3

Bharath Jeeva
Gender: Male
ERROR 122 (HY000): IDB-9029: Window function are only supported for InfiniDB tables.

We have a standalone infinidb(Server version: 5.1.73 InfiniDB 4.5.1-3) installed on RHEL 6.4 (Santiago) system.

 

while executing a select query, its throwing error as

 

"ERROR 122 (HY000): IDB-9029: Window function are only supported for InfiniDB tables"

 

So tables created in Server were not being traded as Infinidb tables.

 

how to fix it ? any suggestions

 

Thanks,
Bharath Jeeva

radams
radams's picture
Offline
Last seen: 21 hours 52 min ago
Joined: Jan 3 2011
Administrator

Posts: 492

Robert Adams
  Hi Bharath, Are the tables

 

 

Hi Bharath,

 

Are the tables in the query created with the InfiniDB Engine?

 

Thanks,

 

Robert