yoongkang0122

yoongkang0122 / Solutions

Created December 8, 2018 05:50 — forked from vikas-gonti/Solutions

Solution to 20 questions at http://nn02.itversity.com/cca175/

	:'Problem 1
	#Connect to the MySQL database on the itversity labs using sqoop and import all of the data from the orders table into HDFS
	Output Requirements
	#Place the customer files in the HDFS directory
	#/user/yourusername/problem1/solution/
	#Replace yourusername with your OS user name
	#Use a text format with comma as the columnar delimiter
	#Load every order record completely'

	sqoop import \

yoongkang0122 / pandas_dbms.py

Created January 5, 2018 07:39 — forked from catawbasam/pandas_dbms.py

Python PANDAS : load and save Dataframes to sqlite, MySQL, Oracle, Postgres

	# -- coding: utf-8 --
	"""
	LICENSE: BSD (same as pandas)
	example use of pandas with oracle mysql postgresql sqlite
	- updated 9/18/2012 with better column name handling; couple of bug fixes.
	- used ~20 times for various ETL jobs. Mostly MySQL, but some Oracle.

	to do:
	save/restore index (how to check table existence? just do select count(*)?),
	finish odbc,