Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded 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 ?
sagar nikam 2012-10-28, 04:32
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?)