| select user_name from enwiki_p.user where user_id between 1 and 1000000 and... |
8 years ago |
| select user_name from enwiki_p.user where user_id between 1 and 1000 and... |
8 years ago |
| select user_name from enwiki_p.user where user_id between 1 and 1000 and... |
8 years ago |
| select user_name from enwiki_p.user where user_id between 1 and 1000 and... |
8 years ago |
| use datasets_p;
select * from enwiki_sessions_20150801 limit 10; |
8 years ago |
| use datasets_p;
select * from enwiki_sessions_20150801 where user like... |
8 years ago |
| use datasets_p;
select * from enwiki_sessions_20150801 where user like... |
8 years ago |
| use datasets_p;
select * from enwiki_sessions_20150801 limit 50; |
8 years ago |
| use datasets_p;
select * from enwiki_sessions_20150801; |
8 years ago |
| datasets_p.enwiki_sessions_20150801; |
8 years ago |
| select user_name from user where user_id between 1 and 100;
|
8 years ago |
| select user_name from user where user_id between 1, 100;
|
8 years ago |
| select user_name from user where user_id between(1, 100);
|
8 years ago |
| #SELECT user_name FROM enwiki_p.user WHERE lower(user_name) LIKE... |
8 years ago |
| #SELECT user_name FROM enwiki_p.user WHERE lower(user_name) LIKE... |
8 years ago |
| #SELECT user_name FROM enwiki_p.user WHERE lower(user_name) LIKE... |
8 years ago |
| #SELECT user_name FROM enwiki_p.user WHERE lower(user_name) LIKE... |
8 years ago |
| #SELECT user_name FROM enwiki_p.user WHERE lower(user_name) LIKE... |
8 years ago |
| SELECT user_name FROM enwiki_p.user WHERE lower(user_name) LIKE... |
8 years ago |
| SELECT user_name FROM enwiki_p.user WHERE user_name ILIKE 'a%';
#select... |
8 years ago |
| select count(*) from user;
#SELECT * from enwiki_p.revision_userindex LIMIT... |
8 years ago |
| select count(user_name) from user limit 50;
#SELECT * from... |
8 years ago |
| select count(*) from user limit 50;
#SELECT * from... |
8 years ago |
| select * from user limit 50;
#SELECT * from enwiki_p.revision_userindex... |
8 years ago |
| select count(*) from user limit 50;
#SELECT * from... |
8 years ago |
| select count(*) from user limit 50;
#SELECT * from... |
8 years ago |
| select count(user_name) from user limit 50;
#SELECT * from... |
8 years ago |
| select count(user_name) from user;
#SELECT * from... |
8 years ago |
| select * from user limit 50;
#SELECT * from enwiki_p.revision_userindex... |
8 years ago |
| show tables;
#SELECT * from enwiki_p.revision_userindex LIMIT 50;
#SELECT... |
8 years ago |
| use datasets_p;
select * from facebook_links_wosn_2009 LIMIT 50;
#SELECT *... |
8 years ago |
| use datasets_p;
show tables;
#SELECT * from enwiki_p.revision_userindex... |
8 years ago |
| use datasets_p;
#SELECT * from enwiki_p.revision_userindex LIMIT 50;
#SELECT... |
8 years ago |
| show tables;
#SELECT * from enwiki_p.revision_userindex LIMIT 50;
#SELECT... |
8 years ago |
| show datasets;
#SELECT * from enwiki_p.revision_userindex LIMIT 50;
#SELECT... |
8 years ago |
| SELECT * from enwiki_p.revision_userindex LIMIT 50;
#SELECT rev_timestamp... |
8 years ago |
| SELECT rev_timestamp FROM enwiki_p.revision_userindex WHERE rev_user_text... |
8 years ago |
