Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive >> mail # user >> How to load phpmyadmin dump .sql file into hive ?


Copy link to this message
-
How to load phpmyadmin dump .sql file into hive ?
i have below .sql file
file---->
==============================================================-- Database: `manager`
-- Table structure for table `access`
--

CREATE TABLE IF NOT EXISTS `access` (
`id_access` int(11) NOT NULL AUTO_INCREMENT,
`no_of_waiter` int(11) NOT NULL,
`name` varchar(45) NOT NULL,
`macaddress` mediumtext NOT NULL,
PRIMARY KEY (`id_access`),
KEY `no_of_waiter` (`no_of_waiter`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=99 ;

--
-- Dumping data for table `access`
INSERT INTO `access` (`id_access`, `no_of_waiter`, `name`, `macaddress`)
VALUES
(66, 19, 'antonio', 'Mozilla/5.0 (compatible)'),
(2, 6, 'jota', 'Mozilla/5.0 (Windows NT 6.1) ');
==============================================================there are thousands of row,but due to space problem,i m showing only two
rows data

i googled out & get "sqoop"
it dont have good tutorials to explain step by step

another way is that i have web address of this phpmyadmin with username &
passsword also

tell me both ways (which is best & easiest way to import?)
+
Shreepadma Venugopalan 2012-10-28, 18:03
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB