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

April 15, 2013

Summary:

  • MyISAM is better for selects
  • InnoDB is better for inserts and updates

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


How to kill a hadoop job

April 10, 2013

Hadoop job -list

List running hadoop jobs and their job ids.

Hadoop job –kill <JobID>

#hadoop

Go to comments


Deep Learning and Artificial Intelligence Newsletter

Get discount coupons, free machine learning material, and new course announcements