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
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