Here is the query -
String sql = "SELECT sid_per_id, sid_mah_id, sid_itm_id, sid_prm_id,
sid_cha_code, sid_service, sid_itm_dist "
+ " FROM \"" + SHOP_ITEM_BITMAP_CACHE +
"\".ShopItemBitmap as bitmap "
+ " JOIN \"" + PROD_HIER_CACHE + "\".ProdHier
as prod ON
prod.GHD_LEV_6 = bitmap.SID_ITM_ID and prod.GHD_HIE_ID = 0 and
prod.ghd_lev_2_desc = 'WINE' "
+ " JOIN \"" + MRKT_POD_ACV_CACHE +
"\".MarketPodAcv as mkt ON
mkt.CHLD_MRKT_KEY = bitmap.SID_MAH_ID and mkt.MRKT_KEY = 4378038 AND
mkt.prd_id = 712 "
+ " WHERE bitmap.SID_PER_ID = 712 ";
--
View this message in context:
http://apache-ignite-users.70518.x6.nabble.com/Host-Arrays-in-C-API-tp3707p3716.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.
