MyISAM vs. InnoDB, and how to switch engines on existing tables

April 15, 2013

Summary:

To switch your table to MyISAM:

ALTER TABLE table_name ENGINER = MyISAM;

To switch your table to InnoDB:

ALTER TABLE table_name ENGINER = InnoDB;

Go to comments

Pig Error -> ERROR 1070: Could not resolve count using imports

April 11, 2013

Or:

ERROR 1070: Could not resolve sum using imports

COUNT() and SUM() are case sensitive, you need to capitalize them.

#hadoop #pig

Go to comments

April 10, 2013

Hadoop job -list

List running hadoop jobs and their job ids.

Hadoop job –kill <JobID>

#hadoop

Go to comments