[jira] [Created] (ZEPPELIN-2576) dynamic querying of Temp Table in Spark R returns Error: is.character(x) is not TRUE

[Prasanth (JIRA)]

Prasanth created ZEPPELIN-2576:
----------------------------------

             Summary: dynamic querying of Temp Table in Spark R returns Error: 
is.character(x) is not TRUE
                 Key: ZEPPELIN-2576
                 URL: https://issues.apache.org/jira/browse/ZEPPELIN-2576
             Project: Zeppelin
          Issue Type: Bug
          Components: r-interpreter
    Affects Versions: 0.7.1
         Environment: AWS Ubuntu 16.04 Spark 2.1.1
            Reporter: Prasanth


I store a temptable in PySpark, which I query in sparkR based the value 
selected as follows:

I have a select in Pyspark, where I choose the state:
{quote}
df.registerTempTable("Tble_State")
selectedState =  z.select("Select Store: " states)
z.put("selectedState",selectedState)
{quote}

I access the *selectedState*  in SparkR and query:
{quote}
state = z.get("selectedState")
query = paste("select * from tableState where state =",state)
dfState = sql(sqlContext,query)
{quote}

The above Spark R code works for the first time, but fails when run again and 
throws the following error:
{quote}
Error: is.character\(x\) is not TRUE
{quote}



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)