Hi Niranda, Thanks a lot! this worked On Tue, Mar 8, 2016 at 12:50 PM, Niranda Perera <nira...@wso2.com> wrote:
> Hi Charini, > > there is a problem with the query here. use the following query > > INSERT OVERWRITE TABLE All_three > > select * from ( > SELECT SYMBOL, VOLUME FROM First > UNION > SELECT SYMBOL, VOLUME FROM Middle > UNION > SELECT SYMBOL, VOLUME FROM Third > > ) temp; > > Essentially what we do here is, wrapping the union result into one > temporary data element named 'temp' and select everything from there. > > SparkSQL parser only takes one single select element in the insert > queries, and at the end of a select query it expects a limit (if > available). therefore, you need to wrap the subsequent select statements > into one select element. > > Hope this resolves your issue > > Best > > On Tue, Mar 8, 2016 at 8:47 AM, Charini Nanayakkara <chari...@wso2.com> > wrote: > >> Hi, >> The following query was attempted to be executed when performing batch >> analytics with WSO2 DAS using Spark SQL. Tables 'First', 'Middle' and >> 'Third' are required to be combined and written to table 'All_three'. >> >> INSERT OVERWRITE TABLE All_three SELECT SYMBOL, VOLUME FROM First UNION >> SELECT SYMBOL, VOLUME FROM Middle UNION SELECT SYMBOL, VOLUME FROM Third; >> >> >> Following error is displayed on WSO2 DAS when this query is executed: >> >> ERROR: [1.79] failure: ``limit'' expected but `union' found INSERT OVERWRITE >> TABLE X1234_All_three SELECT SYMBOL, VOLUME FROM X1234_First UNION SELECT >> SYMBOL, VOLUME FROM X1234_Middle UNION SELECT SYMBOL, VOLUME FROM >> X1234_Third ^ >> >> >> Using LIMIT with UNION is not a necessity to the best of my knowledge. >> Enclosing the SELECT queries in parentheses too was attempted which didn't >> work. What am I doing wrong here? Thank you in advance! >> >> >> >> >> >> -- >> Charini Vimansha Nanayakkara >> Software Engineer at WSO2 >> Mobile: 0714126293 >> >> >> _______________________________________________ >> Dev mailing list >> Dev@wso2.org >> http://wso2.org/cgi-bin/mailman/listinfo/dev >> >> > > > -- > *Niranda Perera* > Software Engineer, WSO2 Inc. > Mobile: +94-71-554-8430 > Twitter: @n1r44 <https://twitter.com/N1R44> > https://pythagoreanscript.wordpress.com/ > -- Charini Vimansha Nanayakkara Software Engineer at WSO2 Mobile: 0714126293
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
