hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Daniel Lopes <dan...@bankfacil.com.br>
Subject Re: Subquery in select statement
Date Tue, 08 Sep 2015 22:04:12 GMT
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
http://about.me/dannyeuu

Av. Nova Independência, 956, São Paulo, SP
Bairro Brooklin Paulista
CEP 04570-001
https://www.bankfacil.com.br


On Thu, Sep 3, 2015 at 4:12 PM, Daniel Lopes <daniel@bankfacil.com.br>
wrote:

> 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 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ão Paulo, SP
> Bairro Brooklin Paulista
> CEP 04570-001
> https://www.bankfacil.com.br
>
>

Mime
View raw message