We are getting the following error when we try running a query :
Failed to get a double value from java.lang.String: PINYX; CODE: 139264
The query is as follows :
select * from ( SELECT 1 OrderNo,max(FundName) Fundcategory,sum(1M_Rank) 1M_Rank,Sum(1M_Rank_Lip) 1M_Rank_Lip,sum(1m_Perc) 1M_Perc,sum(1M_Perc_Lip) 1M_Perc_Lip,sum(QTD_Rank) QTD_Rank,sum(QTD_Rank_Lip) QTD_Rank_Lip,sum(QTD_Perc) QTD_Perc,sum(QTD_Perc_Lip) QTD_Perc_Lip,sum(3M_Rank) 3M_Rank,sum(3M_Rank_Lip) 3M_Rank_Lip,sum(3M_Perc) 3M_Perc,sum(3M_Perc_Lip) 3M_Perc_Lip,sum(YTD_Rank) YTD_Rank,sum(YTD_Rank_Lip) YTD_Rank_Lip,sum(YTD_Perc) YTD_Perc,sum(YTD_Perc_Lip) YTD_Perc_Lip,sum(1Y_Rank) 1Y_Rank,sum(1Y_Rank_Lip) 1Y_Rank_Lip,sum(1Y_Perc) 1Y_Perc,sum(1Y_Perc_Lip) 1Y_Perc_Lip,sum(3Y_Rank) 3Y_Rank,sum(3Y_Rank_Lip) 3Y_Rank_Lip,sum(3Y_Perc) 3Y_Perc,sum(3Y_Perc_Lip) 3Y_Perc_Lip,sum(5Y_Rank) 5Y_Rank,sum(5Y_Rank_Lip) 5Y_Rank_Lip,sum(5Y_Perc) 5Y_Perc,sum(5Y_Perc_Lip) 5Y_Perc_Lip,sum(10Y_Rank) 10Y_Rank,sum(10Y_Rank_Lip) 10Y_Rank_Lip,sum(10Y_Perc) 10Y_Perc,sum(10Y_Perc_Lip) 10Y_Perc_Lip from (select FundName FundName,'' Category,1M_Rank, 0 1M_Rank_Lip,1M_Perc, 0 1M_Perc_Lip,QTD_Rank, 0 QTD_Rank_Lip,QTD_Perc, 0 QTD_Perc_Lip,3M_Rank, 0 3M_Rank_Lip,3M_Perc, 0 3M_Perc_Lip,YTD_Rank, 0 YTD_Rank_Lip,YTD_Perc, 0 YTD_Perc_Lip,1Y_Rank, 0 1Y_Rank_Lip,1Y_Perc, 0 1Y_Perc_Lip,3Y_Rank, 0 3Y_Rank_Lip,3Y_Perc, 0 3Y_Perc_Lip,5Y_Rank, 0 5Y_Rank_Lip,5Y_Perc, 0 5Y_Perc_Lip,10Y_Rank, 0 10Y_Rank_Lip,10Y_Perc, 0 10Y_Perc_Lip FROM LipperRank L1 WHERE L1.NASDAQ='PINYX' ) union SELECT 2 OrderNo,max(Category) Fundcategory ,sum(1M_Rank) 1M_Rank,sum(1M_Rank_Lip) 1M_Rank_Lip,sum(1M_Perc) 1M_Perc,sum(1M_Perc_Lip) 1M_Perc_Lip,sum(QTD_Rank) QTD_Rank,sum(QTD_Rank_Lip) QTD_Rank_Lip,sum(QTD_Perc) QTD_Perc,sum(QTD_Perc_Lip) QTD_Perc_Lip,sum(3M_Rank) 3M_Rank,sum(3M_Rank_Lip) 3M_Rank_Lip,sum(3M_Perc) 3M_Perc,sum(3M_Perc_Lip) 3M_Perc_Lip,sum(YTD_Rank) YTD_Rank,sum(YTD_Rank_Lip) YTD_Rank_Lip,sum(YTD_Perc) YTD_Perc,sum(YTD_Perc_Lip) YTD_Perc_Lip,sum(1Y_Rank) 1Y_Rank,sum(1Y_Rank_Lip) 1Y_Rank_Lip,sum(1Y_Perc) 1Y_Perc,sum(1Y_Perc_Lip) 1Y_Perc_Lip,sum(3Y_Rank) 3Y_Rank,sum(3Y_Rank_Lip) 3Y_Rank_Lip,sum(3Y_Perc) 3Y_Perc,sum(3Y_Perc_Lip) 3Y_Perc_Lip,sum(5Y_Rank) 5Y_Rank,sum(5Y_Rank_Lip) 5Y_Rank_Lip,sum(5Y_Perc) 5Y_Perc,sum(5Y_Perc_Lip) 5Y_Perc_Lip,sum(10Y_Rank) 10Y_Rank,sum(10Y_Rank_Lip) 10Y_Rank_Lip,sum(10Y_Perc) 10Y_Perc,sum(10Y_Perc_Lip) 10Y_Perc_Lip from (select FundName FundName,'' Category,1M_Rank, 0 1M_Rank_Lip,1M_Perc, 0 1M_Perc_Lip,QTD_Rank, 0 QTD_Rank_Lip,QTD_Perc, 0 QTD_Perc_Lip,3M_Rank, 0 3M_Rank_Lip,3M_Perc, 0 3M_Perc_Lip,YTD_Rank, 0 YTD_Rank_Lip,YTD_Perc, 0 YTD_Perc_Lip,1Y_Rank, 0 1Y_Rank_Lip,1Y_Perc, 0 1Y_Perc_Lip,3Y_Rank, 0 3Y_Rank_Lip,3Y_Perc, 0 3Y_Perc_Lip,5Y_Rank, 0 5Y_Rank_Lip,5Y_Perc, 0 5Y_Perc_Lip,10Y_Rank, 0 10Y_Rank_Lip,10Y_Perc, 0 10Y_Perc_Lip FROM LipperRank L1 WHERE L1.NASDAQ='PINYX' union select '' FundName,Category Category,0 1M_Rank, 1M_Rank 1M_Rank_Lip,0 1M_Perc, 1M_Perc 1M_Perc_Lip,0 QTD_Rank, QTD_Rank QTD_Rank_Lip,0 QTD_Perc, QTD_Perc QTD_Perc_Lip,0 3M_Rank, 3M_Rank 3M_Rank_Lip,0 3M_Perc, 3M_Perc 3M_Perc_Lip,0 YTD_Rank, YTD_Rank YTD_Rank_Lip,0 YTD_Perc, YTD_Perc YTD_Perc_Lip,0 1Y_Rank, 1Y_Rank 1Y_Rank_Lip,0 1Y_Perc, 1Y_Perc 1Y_Perc_Lip,0 3Y_Rank, 3Y_Rank 3Y_Rank_Lip,0 3Y_Perc, 3Y_Perc 3Y_Perc_Lip,0 5Y_Rank, 5Y_Rank 5Y_Rank_Lip,0 5Y_Perc, 5Y_Perc 5Y_Perc_Lip,0 10Y_Rank, 10Y_Rank 10Y_Rank_Lip,0 10Y_Perc, 10Y_Perc 10Y_Perc_Lip FROM LipperRank L2 WHERE L2.CategoryClass = (select distinct LipperClass FROM LipperRank L3 where L3.NASDAQ='PINYX')) )].
ERROR: Failed to get a double value from java.lang.String: PINYX; CODE: 139264
Not sure what would be a way to fix this..
|