Hi Rosan,
Thanks for your response. Kindly refer the following query and stack trace.
I have checked same query in hive, It works perfectly. In case i have
removed "in" in where class, it works in spark
SELECT If(ISNOTNULL(SUM(`Sheet1`.`Runs`)),SUM(`Sheet1`.`Runs`),0) AS
`Sheet1_Runs` ,`Sheet1`.`Teams` AS `Sheet1_Teams` FROM
default.Dashboard_Sheet1_20150812010131201 AS `Sheet1` INNER JOIN (SELECT
`Sheet1`.`Teams` AS
`Teams_0`,If(ISNOTNULL(COUNT(`Sheet1`.`Teams`)),COUNT(`Sheet1`.`Teams`),0)
AS `Measure_0` FROM default.Dashboard_Sheet1_20150812010131201 AS `Sheet1`
WHERE ((((`Sheet1`.`Teams` IN ('Chennai Super Kings')) AND
(`Sheet1`.`Teams` <> '' )) AND (NOT(`Sheet1`.`Teams` IS NULL)))) GROUP BY
`Sheet1`.`Teams` ORDER BY `Measure_0` DESC LIMIT 5 ) `T_0` ON (
`Sheet1`.`Teams` =`T_0`.`Teams_0` ) WHERE ((((`Sheet1`.`Teams` IN ('Chennai
Super Kings')) AND (`Sheet1`.`Teams` <> '' )) AND (NOT(`Sheet1`.`Teams` IS
NULL)))) GROUP BY `Sheet1`.`Teams`
at Syncfusion.ThriftHive.Base.HqlCommand.ExecuteReader()
at
Syncfusion.Dashboard.Base.Data.HiveQueryBuilder.ExecuteReaderQuery(String
query, String connectionString) in
f:\Back_To_Svn\source\base\dashboard.base\src\Data\HiveServer.cs:line 409
at Syncfusion.Dashboard.Base.Data.ServerDataProvider.GetTable(String
tableName, List`1 schemaInfoCollection, List`1
originalSchemaInfoCollection, List`1 initialFilterList, List`1
viewerFilterList, Boolean isSelectQueryForServerModeFilterPopup, Boolean
isNestedFilter) in
f:\Back_To_Svn\source\base\dashboard.base\src\Data\Data.cs:line 536
at
Syncfusion.Dashboard.Base.Engine.RelationalEngine.GetDataFromMainSource(List`1
schemaInfos, List`1 viewerFilterList) in
f:\Back_To_Svn\source\base\dashboard.base\src\Engine\RelationDataEngine.cs:line
902
at
DashboardService.DashboardService.ApplyFilterServerMode(RelationalEngine
engine, String ReportName, Boolean Drilled, Boolean& useDefaultProperties,
Boolean isParamsColumn, SchemaInfo paramsSchema) in
f:\Back_To_Svn\source\js\dashboardsamples\wcf\Common\DataProcessor.cs:line
1030
at DashboardService.DashboardService.ApplyFilter(RelationalEngine
engine, String ReportName, Boolean Drilled, Boolean& useDefaultProperties,
Boolean isParamsColumn, SchemaInfo paramsSchema) in
f:\Back_To_Svn\source\js\dashboardsamples\wcf\Common\DataProcessor.cs:line
1047
at DashboardService.DashboardService.GetProcessedControlData(List`1
elements, RelationalEngine dataEngine, DashboardItem control,
RelationalReport currentReport) in
f:\Back_To_Svn\source\js\dashboardsamples\wcf\Common\DataProcessor.cs:line
205
at DashboardService.DashboardService.GetGridControlData(DashboardItem
controlObj, List`1& columnList, List`1& gridSchemaInfos, Dictionary`2&
barData, Dictionary`2& formattedColumns, List`1& colourSaturationColumns)
in
f:\Back_To_Svn\source\js\dashboardsamples\wcf\Controls\DashboardGrid.cs:line
115
at DashboardService.DashboardService.GetGridData(DashboardItem
controlObj, Boolean isLoadGrid) in
f:\Back_To_Svn\source\js\dashboardsamples\wcf\Controls\DashboardGrid.cs:line
47
at DashboardService.DashboardService.ControlConfigHelper(DashboardItem
control, Boolean IsLoad, DataFetcherGrid fn) in
f:\Back_To_Svn\source\js\dashboardsamples\wcf\DashboardService.svc.cs:line
1269
Regards,
Ravi
On Tue, Aug 11, 2015 at 11:53 PM, Josh Rosen <rosenvi...@gmail.com> wrote:
> Can you share a query or stack trace? More information would make this
> question easier to answer.
>
> On Tue, Aug 11, 2015 at 8:50 PM, Ravisankar Mani <rrav...@gmail.com>
> wrote:
>
>> Hi all,
>>
>> We got an exception like
>> “org.apache.spark.sql.catalyst.analysis.UnresolvedException: Invalid call
>> to dataType on unresolved object” when using some where condition queries.
>> I am using 1.4.0 version spark. Is this exception resolved in latest spark?
>>
>>
>> Regards,
>> Ravi
>>
>
>
