Re: 答复: [ANNOUNCE] New Hive Committer - Wei Zheng

2016-03-10 Thread Daniel Lopes
ache.org > 主题: Re: [ANNOUNCE] New Hive Committer - Wei Zheng > > Congratulations Wei Zheng > > Thanks, > MAdhu > Help ever, Hurt never > > > > > -- *Daniel Lopes, B.Eng* Data Scientist - BankFacil CREA/SP 5069410560 <http://edital.confea.org.br/Consulta

Re: Best way to load CSV file into Hive

2015-10-30 Thread Daniel Lopes
the intended recipient. If you receive this e-mail in error please delete > it from your system immediately and notify us either by e-mail or > telephone. You should not copy, forward or otherwise disclose the content > of the e-mail. The views expressed in this communication may not >

Hive 1.0.0 Error: cannot be cast

2015-10-23 Thread Daniel Lopes
.exec.MapJoinOperator.processOp(MapJoinOperator.java:295) ... 13 more FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask MapReduce Jobs Launched: Stage-Stage-8: Map: 1 HDFS Read: 0 HDFS Write: 0 FAIL Total MapReduce CPU Time Spent: 0 msec Command exitin

Better way to do UDF's for Hive

2015-10-01 Thread Daniel Lopes
in a good way. Thanks, *Daniel Lopes, B.Eng* Data Scientist - BankFacil CREA/SP 5069410560 <http://edital.confea.org.br/ConsultaProfissional/cartao.aspx?rnp=2613651334> Mob +55 (18) 99764-2733 <callto:+5518997642733> Ph +55 (11) 3522-8009 http://about.me/dannyeuu Av. Nova Independênc

Re: Failed to execute command on hive - Relative path in absolute URI

2015-10-01 Thread Daniel Lopes
Hi, To call a hive conf, get by this: ${hiveconf:NAME_OF_PROPERTY} Bye *Daniel Lopes, B.Eng* Data Scientist - BankFacil CREA/SP 5069410560 <http://edital.confea.org.br/ConsultaProfissional/cartao.aspx?rnp=2613651334> Mob +55 (18) 99764-2733 <callto:+5518997642733> Ph +55 (11) 35

Re: Organising Hive Scripts

2015-09-14 Thread Daniel Lopes
Thanks Erwan, I needed this too, and works fine for me. *Daniel Lopes, B.Eng* Data Scientist - BankFacil CREA/SP 5069410560 <http://edital.confea.org.br/ConsultaProfissional/cartao.aspx?rnp=2613651334> Mob +55 (18) 99764-2733 <callto:+5518997642733> Ph +55 (11) 3522-8009 htt

Re: [ANNOUNCE] New Hive Committer - Lars Francke

2015-09-08 Thread Daniel Lopes
Congrats! *Daniel Lopes, B.Eng* Data Scientist - BankFacil CREA/SP 5069410560 <http://edital.confea.org.br/ConsultaProfissional/cartao.aspx?rnp=2613651334> Mob +55 (18) 99764-2733 <callto:+5518997642733> Ph +55 (11) 3522-8009 http://about.me/dannyeuu Av. Nova Independência, 956, S

Re: Subquery in select statement

2015-09-08 Thread Daniel Lopes
Sorry, but there are something that I can do in this case? *Daniel Lopes, B.Eng* Data Scientist - BankFacil CREA/SP 5069410560 <http://edital.confea.org.br/ConsultaProfissional/cartao.aspx?rnp=2613651334> Mob +55 (18) 99764-2733 <callto:+5518997642733> Ph +55 (11) 3522-8009 htt

Subquery in select statement

2015-09-03 Thread Daniel Lopes
Hi, There are somthing that I can do this? SELECT tb.id, (SELECT tb3.field FROM database.table2 tb2 JOIN database.table3 tb3 ON ( tb3.id = tb2.table3_id) ORDER BY tb3.date DESC LIMIT 1) AS tb3_field FROM database.table1 tb1 Best, *Daniel Lopes, B.Eng* Data Scientist - BankFacil CREA/SP