Category Database

NoSQL at Twitter: Why / How they use Scribe, Hadoop/Pig, HBase, Cassandra, and FlockDB for data analytics?

Here’s some interesting NoSQL stuff guys. It’s a presentation about how Twitter uses NoSQL for analytics by Kevin Weil (@kevinweil), Analytics Lead, Twitter. About the presentation Collecting data (Scribe) Storing and Analyzing data (Hadoop) Rapid Learning over Big Data (Pig) .. and Cassandra, HBase, FlockDB. For those who are not aware of the said technologies… […]

SQL: How to copy just table structure or create a table from another table without copying any values from the old table?

Here’s how it can be done: CREATE TABLE new_table AS (SELECT * FROM old_table WHERE 1=2); Eg: CREATE TABLE student AS (SELECT * FROM person WHERE 1=2); This would create a new table called student that includes all columns from the person table, but no data from the person table.