How to move Hive data table to MySql?


Problem :

I would like to know how I can move date from Hive to MySQL?

I have seen example on how to move hive data to Amazon DynamoDB but not for a RDBMS like MySQL. Here is the example that I saw with DynamoDB:

CREATE EXTERNAL TABLE tbl1 ( name string, location string )
STORED BY 'org.apache.hadoop.hive.dynamodb.DynamoDBStorageHandler'
TBLPROPERTIES ("dynamodb.table.name" = "table",
"dynamodb.column.mapping" = "name:name,location:location") ;

I would like to do the same but with MySQL instead. I wonder if I need to code my own StorageHandler? I also to do not want to use sqoop. I want to be able to do my query directly in my HiveQL script.



Solution :

You'd currently need a JDBC StorageHandler, which one has not been created just yet, but you could certain build your own.

There is currently an issue report for this which you can follow here:

https://issues.apache.org/jira/browse/HIVE-1555


Mysql Tutorials

Mysql Howto..

MySQL - How to simplify this query?

How to pagination in mysql php

How to insert long number in mysql

PHP: How to save mysql to excel file to a directory and not prompt user to download

How to update row in php/mysql?

MySQL query with many AND OR. Need to understand how (in what order) data is filtered

How to input Date and Time info from a PHP form into a MySQL table in datetime format

How to apply CSS to dynamically generated PHP database results

How to fill a single MySQL table with certain columns from multiple CSV files?

Mac OS X & MAMP - How to run mysql without having to type in the full path?

How to convert a class object to generic object type?

How to check if row exists in mysql, in Node js

How to select all rows HTML table

How to paginate the filtered results in php mysql?

ASP.Net Cache problem/question. Where and how to cache. | Costum ADO.Net code

How to run two queries?(Joomla, mysql)

How can I extract the value of a variable and re-use that value until it is overwritten

How to make a dropdownlist using mysql query with foreach?

How to use MySQL in static function in c# [closed]

How can I pass mysql result in object using node js?

How to get all images which belongs to user in one “loop”

How to create a query in MySQL to subtract consecutive rows based on the date and a distinctive field?

How insert 2 related records in mysql

Grails GORM how to load existing remote DB tables in my application

how to add a sub select query

How to fetch data from MySQL

How to embed mysql db content into 3rd party sites without providing remote access

How to use a PHP variable in Inner Join MYSQL query?

How to manage database and queries of a multi-tagged/multi-categorized article/post

How to get this specific user rankings query in mysql?