Re: ndbcluster problem
The table is very big and uses text columns.
here is the schema:
CREATE TABLE `packagedeals` (
`CacheID` varchar(150) NOT NULL default '',
`isactive` tinyint(1) NOT NULL default '0',
`DocumentID` varchar(5) NOT NULL default '0',
`ItemID` int(11) NOT NULL default '0',
`PackageID` int(11) NOT NULL default '0',
`SupplierID` int(11) NOT NULL default '0',
`SupplierCode` varchar(5) NOT NULL default '',
`SupplierName` varchar(50) NOT NULL default '',
`cityCode` char(3) NOT NULL default '',
`CityName` varchar(100) NOT NULL default '',
`CityName_Heb` varchar(50) default NULL,
`CountryName` varchar(100) NOT NULL default '',
`CountryName_Heb` varchar(100) default NULL,
`YaadNofesh` tinyint(1) default NULL,
`DealNights` smallint(6) default NULL,
`ItemDowType` varchar(50) default NULL,
`ItemDowText` varchar(50) default NULL,
`CurrencyCode` varchar(10) default NULL,
`ExtraTotal` float default NULL,
`ExtraApTax` float default NULL,
`ExtraRegTax` float default NULL,
`ExtraTrsfTax` float default NULL,
`ExtraSecureTax` float default NULL,
`IncludedExtraApTax` tinyint(1) NOT NULL default '0',
`IncludedExtraRegTax` tinyint(1) NOT NULL default '0',
`IncludedExtraTrsfTax` tinyint(1) NOT NULL default '0',
`IncludedExtraSecureTax` tinyint(1) NOT NULL default '0',
`OutFlightID` int(11) NOT NULL default '0',
`OutAirlineCode` char(3) default NULL,
`OutAirlineName` varchar(100) default NULL,
`OutFlightNumber` varchar(5) default NULL,
`OutTakeoffAirportCode` char(3) default NULL,
`OutTakeoffAirportName` varchar(100) default NULL,
`OutTakeoffAirportName_Heb` varchar(100) default NULL,
`OutTakeoffCityName` varchar(100) default NULL,
`OutTakeoffCityName_Heb` varchar(100) default NULL,
`OutTakeOffTerminal` varchar(50) default NULL,
`OutLandingAirportCode` char(3) default NULL,
`OutLandingAirportName` varchar(100) default NULL,
`OutLandingAirportName_Heb` varchar(100) default NULL,
`OutLandingCityName` varchar(100) default NULL,
`OutLandingCityName_Heb` varchar(100) default NULL,
`OutViaAirportCode` char(3) default NULL,
`OutViaAirportName` varchar(100) default NULL,
`OutViaAirportName_Heb` varchar(100) default NULL,
`OutViaCityName` varchar(100) default NULL,
`OutViaCityName_Heb` varchar(100) default NULL,
`OutTakeOffDate` decimal(8,0) NOT NULL default '0',
`OutTakeOffTime` decimal(4,0) NOT NULL default '0',
`OutLandingDate` decimal(8,0) NOT NULL default '0',
`OutLandingTime` decimal(4,0) NOT NULL default '0',
`OutClassCode` varchar(10) NOT NULL default '',
`InFlightID` int(11) NOT NULL default '0',
`InAirlineCode` char(3) default NULL,
`InAirlineName` varchar(100) default NULL,
`InFlightNumber` varchar(5) default NULL,
`InTakeoffAirportCode` char(3) default NULL,
`InTakeoffAirportName` varchar(100) default NULL,
`InTakeoffAirportName_Heb` varchar(100) default NULL,
`InTakeoffCityName` varchar(100) default NULL,
`InTakeoffCityName_Heb` varchar(100) default NULL,
`InTakeOffTerminal` varchar(50) default NULL,
`InLandingAirportCode` char(3) default NULL,
`InLandingAirportName` varchar(100) default NULL,
`InLandingAirportName_Heb` varchar(100) default NULL,
`InLandingCityName` varchar(100) default NULL,
`InLandingCityName_Heb` varchar(100) default NULL,
`InViaAirportCode` char(3) default NULL,
`InViaAirportName` varchar(100) default NULL,
`InViaAirportName_Heb` varchar(100) default NULL,
`InViaCityName` varchar(100) default NULL,
`InViaCityName_Heb` varchar(100) default NULL,
`InTakeOffDate` decimal(8,0) NOT NULL default '0',
`InTakeOffTime` decimal(4,0) NOT NULL default '0',
`InLandingDate` decimal(8,0) NOT NULL default '0',
`InLandingTime` decimal(4,0) NOT NULL default '0',
`InClassCode` varchar(10) NOT NULL default '',
`OutSeats` int(11) NOT NULL default '0',
`InSeats` int(11) NOT NULL default '0',
`FlagPackage` int(11) NOT NULL default '0',
`FlagByFlightsCombinations` tinyint(1) default NULL,
`SystemId` int(11) NOT NULL default '0',
`SystemName` varchar(50) NOT NULL default '',
`HotelID` int(11) default NULL,
`HotelName` varchar(50) default NULL,
`HotelName_Heb` varchar(50) default NULL,
`HotelCategory` varchar(5) default NULL,
`HotelBoard` varchar(5) default NULL,
`HotelBoardDesc` varchar(30) default NULL,
`HotelBoardDesc_Heb` varchar(50) default NULL,
`HotelRoomType` varchar(100) default NULL,
`HotelRoomType_Heb` varchar(100) default NULL,
`HotelAddress` varchar(255) default NULL,
`HotelDesc` text,
`HotelDesc_Heb` text,
`Fare` float default NULL,
`Commission` varchar(5) default NULL,
`FlagNeto` int(11) NOT NULL default '0',
`PaxRemarks` text,
`PaxRemarksHeb` text,
`AgentRemarks` text,
`AgentRemarksHeb` text,
`FlagOffLine` tinyint(1) NOT NULL default '0',
`FlagIncludeFlights` tinyint(1) NOT NULL default '0',
`DealCategory` varchar(30) NOT NULL default '',
PRIMARY KEY (`CacheID`,`SystemId`),
KEY `idealcategory` (`DealCategory`),
KEY `iTakeoffDateTime` (`OutTakeOffDate`,`OutTakeOffTime`),
KEY `icitycode` (`cityCode`),
KEY `iouttakeoffdate` (`OutTakeOffDate`),
KEY `ifare` (`Fare`),
KEY `icountryname` (`CountryName`),
KEY `iInLandingDate` (`InLandingDate`),
KEY `icityname` (`CityName`),
KEY `iisactive` (`isactive`),
KEY `iouttakeofftime` (`OutTakeOffTime`)
) ENGINE=ndbcluster DEFAULT CHARSET=latin1;
Thanks,
Arik Peled