Hi this is probably a newbie error - admittedly my first real test of radian (long time listener, first time caller...!) My problem code -- $manifold$ --$include$ Lib --!fullfetch PRAGMA ('progress.percent' = '1','gpgpu' = 'aggressive', 'gpgpu.fp'='32'); SELECT [Grid Block].[ID], [Fuel].[ID], [AngTab].[Ang],[Fuel].[Fuel load],[Fuel].[Width],[Fuel].[Surface Fuel Load],[Grid Block].[Height],[Fuel].[Height]as [fuelHgt], [Grid Block].[Height] - [Fuel].[Height] as [Hgtdif] ,GeomDistance([Grid Block].[Geom (I)],[Fuel].[Geom (I)],0) as [dis], [Fuel].[Fuel Type], [Fuel].[Aspect], [Fuel].[Slope], [Grid Block].[Aspect] as [Grid Block Aspect], --[Fuel].[Fuel Load], --d.searchdis as [Searchdis], FDI as [FDI], GFDI as [GFDI], [Heath Veg Hgt] as [Heathveghgt], AVGWIND as [Avewind], [Grid Block].[x] as [GridX],[Fuel].[x]as [FuelX] ,[Grid Block].[y] as [GridY],[Fuel].[y] as [FuelY] into Hgt from [Grid Block],[Fuel], AngTab--, alcoa_parameters as d where GeomDistance([Grid Block].[Geom (I)], [Fuel].[Geom (I)], 0) < 150 and [Fuel].[Fuel Type]<> 'unclassifiable' THREADS 8 Batch 10; alter table hgt (add mfd_id int64, add index mfd_id_x btree (mfd_id)); alter table Hgt (rename [id 2] [Fuel ID]); alter table Hgt (add searchdis int32, add FDI int32, add GFDI int32, add Heathveghgt int32, add avewind int32); update hgt set searchdis = 150, fdi = 120, gfdi = 120, heathveghgt = 4, avewind = 45; alter table Hgt (rename [aspect 2] [grid block aspect]); alter table hgt (add avgslope float32,add ros float32, add diffx float32, add diffy float32); text This query sequence is part of a bigger sequence but it breaks at the last query above. But then when I run the query either on its own or as the first query in the remainder of sequence, it runs as it should. Log file > -- $manifold$ --$include$ Lib --!fullfetch PRAGMA ('progress.percent' = '1','gpgpu' = 'aggressive', 'gpgpu.fp'='32'); SELECT [Grid Block].[ID], [Fuel].[ID], [AngTab].[Ang],[Fuel].[Fuel load],[Fuel].[Width],[Fuel].[Surface Fuel Load],[Grid Block].[Height],[Fuel].[Height]as [fuelHgt], [Grid Block].[Height] - [Fuel].[Height] as [Hgtdif] ,GeomDistance([Grid Block].[Geom (I)],[Fuel].[Geom (I)],0) as [dis], [Fuel].[Fuel Type], [Fuel].[Aspect], [Fuel].[Slope], [Grid Block].[Aspect] as [Grid Block Aspect], --[Fuel].[Fuel Load], --d.searchdis as [Searchdis], FDI as [FDI], GFDI as [GFDI], [Heath Veg Hgt] as [Heathveghgt], AVGWIND as [Avewind], [Grid Block].[x] as [GridX],[Fuel].[x]as [FuelX] ,[Grid Block].[y] as [GridY],[Fuel].[y] as [FuelY] into Hgt from [Grid Block],[Fuel], AngTab--, alcoa_parameters as d where GeomDistance([Grid Block].[Geom (I)], [Fuel].[Geom (I)], 0) < 150 and [Fuel].[Fuel Type]<> 'unclassifiable' THREADS 8 Batch 10; alter table hgt (add mfd_id int64, add index mfd_id_x btree (mfd_id)); alter table Hgt (rename [id 2] [Fuel ID]); alter table Hgt (add searchdis int32, add FDI int32, add GFDI int32, add Heathveghgt int32, add avewind int32); update hgt set searchdis = 150, fdi = 120, gfdi = 120, heathveghgt = 4, avewind = 45; alter table Hgt (rename [aspect 2] [grid block aspect]); alter table hgt (add avgslope float32, add ros float32, add diffx float32, add diffy float32); Invalid field. Any thoughts on why this might break at this point? I would upload a radian file if this would help. Attachments: sql_sequence.txt
|