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 <[email protected]> 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 > [email protected] > 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 [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
