Hi, @Tishan, Yes I have used 'if not exist' clause when creating the external table. @Gihan, Thanks for the info. I will change and test as you suggested.
Thanks. On Tue, Jun 3, 2014 at 7:05 PM, Gihan Anuruddha <gi...@wso2.com> wrote: > You can use existing tables. In that scenario don't use create query > property. Instead of that use *mapred.jdbc.output.table.name* property in > the hive query to map your existing table. Refer [1] to more information > about hive jdbc handler. > > [1] - > http://kasunweranga.blogspot.com/2012/06/jdbc-storage-handler-for-hive.html > > > On Tue, Jun 3, 2014 at 5:36 PM, Tishan Dahanayakage <tis...@wso2.com> > wrote: > >> Hi Dinesh, >> Can you please check whether you have created external table with 'if not >> exist' clause? >> Eg: CREATE EXTERNAL TABLE IF NOT EXISTS PhoneSalesTable >> >> >> On Tue, Jun 3, 2014 at 5:31 PM, Dinesh Bandara <dine...@wso2.com> wrote: >> >>> Hi, >>> >>> I have created a hive script to get published data in BAM and add that >>> into external mysql databases. Before starting BAM I created database >>> schema and relevant tables in mysql. >>> Hive script execution was succeeded but data were not inserted in to the >>> table. >>> >>> Afterwards I dropped the table from mysql and executed the hive script. >>> Then table was created and inserted data in to table with out any issue. >>> >>> Is this the way it should be worked? Can't we use a existing table >>> through hive script? >>> >>> Thanks, >>> >>> -- >>> *Dinesh Bandara* >>> Software Engineer >>> WSO2 Inc.; http://wso2.com >>> lean.enterprise.middleware >>> >>> >>> _______________________________________________ >>> Dev mailing list >>> Dev@wso2.org >>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>> >>> >> >> >> -- >> Tishan Dahanayakage >> Software Engineer >> WSO2, Inc. >> Mobile:+94 716481328 >> >> Disclaimer: This communication may contain privileged or other >> confidential information and is intended exclusively for the addressee/s. >> If you are not the intended recipient/s, or believe that you may have >> received this communication in error, please reply to the sender indicating >> that fact and delete the copy you received and in addition, you should not >> print, copy, re-transmit, disseminate, or otherwise use the information >> contained in this communication. Internet communications cannot be >> guaranteed to be timely, secure, error or virus-free. The sender does not >> accept liability for any errors or omissions. >> >> _______________________________________________ >> Dev mailing list >> Dev@wso2.org >> http://wso2.org/cgi-bin/mailman/listinfo/dev >> >> > > > -- > W.G. Gihan Anuruddha > Senior Software Engineer | WSO2, Inc. > M: +94772272595 > -- *Dinesh Bandara* Software Engineer WSO2 Inc.; http://wso2.com lean.enterprise.middleware
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev