The Google Visualization API Query Language: Query parse error: Encountered " "," ", "" at line 1, column 24. Was expecting one of:

The Google Visualization API Query Language: Query parse error:

Encountered " "," ", "" at line 1, column 24. Was expecting one of:



I am trying to use google Visualization API function "drawVisualization"

in my JS programme to query google spreadsheet data, but getting "Query

parse error" message with following command:

'query':'select I where J = UP, sum(E) group by I',

This function works fine without "where" option as in following command:

'query':'select I , sum(E) group by I',

I have tried multiple combinations with "where" option, but giving error.

Please suggest. Function code is:

function drawVisualization() { var wrap = new

google.visualization.ChartWrapper({ 'chartType':'ColumnChart',

'dataSourceUrl':'https://docs.google.com/spreadsheet/ccc?key=#gid=0',

'containerId':'visualization', 'query':'select I where J = UP, sum(E)

group by I', 'options': {'title':' Capacity KW/H Requirement)',

'legend':'none'} });

Thanks Vivek