This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
select | |
* | |
from | |
( | |
select | |
dis.user as user, | |
dis.sim as sim | |
from | |
( | |
select |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
http://mt.orz.at/archives/2012/04/hive-1.html | |
のupdate版 | |
svn checkout http://svn.apache.org/repos/asf/hive/trunk hive-trunk | |
cd hive-trunk | |
wget https://issues.apache.org/jira/secure/attachment/12524106/HIVE-2902.3.patch.txt | |
patch -p0 < HIVE-2902.3.patch.txt | |
ant clean package eclipse-files #ただしmakeがないとcleanで怒られるのでオレはant package eclipse-filesしかしてない |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
PREHOOK: query: explain select key from src group by key | |
PREHOOK: type: QUERY | |
POSTHOOK: query: explain select key from src group by key | |
POSTHOOK: type: QUERY | |
ABSTRACT SYNTAX TREE: | |
(TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL key))) (TOK_GROUPBY (TOK_TABLE_OR_COL key)))) | |
STAGE DEPENDENCIES: | |
Stage-1 is a root stage | |
Stage-0 is a root stage |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Hive Anatomy | |
http://www.slideshare.net/nzhang/hive-anatomy | |
Internal Hive | |
http://www.slideshare.net/recruitcojp/internal-hive | |
Indexed Hive | |
http://www.slideshare.net/NikhilDeshpande/indexed-hive | |
Hive – A Petabyte Scale Data Warehouse Using Hadoop |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
ABSTRACT SYNTAX TREE: | |
(TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME hoge))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME piyo))) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)))) | |
STAGE DEPENDENCIES: | |
Stage-1 is a root stage | |
Stage-5 depends on stages: Stage-1 , consists of Stage-4, Stage-3 | |
Stage-4 | |
Stage-0 depends on stages: Stage-4, Stage-3 | |
Stage-2 depends on stages: Stage-0 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
hive> show tables; | |
OK | |
aaa | |
Time taken: 0.124 seconds | |
hive> desc aaa; | |
OK | |
a int | |
b int | |
Time taken: 0.096 seconds | |
hive> select * from aaa limit 1; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
In my younger and more vulnerable years my father gave me some advice that I’ve been turning over in my mind ever since. | |
“Whenever you feel like criticizing any one,” he told me, “just remember that all the people in this world haven’t had the advantages that you’ve had.” | |
僕がまだ年若く、心に傷を負いやすかったころ、父親がひとつ忠告を与えてくれた。その言葉について僕は、ことあるごとに考えをめぐらせてきた。 | |
「誰かのことを批判したくなったときには、こう考えるようにするんだよ。すべての人が、おまえのように恵まれた条件を与えられたわけではないのだと」 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
from ( | |
select | |
... | |
from | |
aaa a | |
left outer join | |
bbb b | |
on | |
a.id=b.id | |
and |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
def solve(length, ants): | |
minimum = 0 | |
maximum = 0 | |
for ant in ants: | |
min_ant = min(ant, length-ant) | |
if min_ant > minimum: | |
minimum = min_ant |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
def solve(m, k): | |
for i1 in k: | |
for i2 in k: | |
for i3 in k: | |
for i4 in k: | |
if i1+i2+i3+i4 == m: | |
print "Yes %d+%d+%d+%d=%d" % (i1, i2, i3, i4, m) | |
break | |
else: | |
continue |
OlderNewer