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 <[email protected]> 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 <[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 > > -- W.G. Gihan Anuruddha Senior Software Engineer | WSO2, Inc. M: +94772272595
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
