as num, result from dw_solar_query where result > 0 and
dt>='{{last7Day}}' and dt<='{{yesterday}}'
group by result order by num desc limit 100 ) top
left join apolo_question aq on top.result=aq.id
) alla
left join
(select fromid,`deleted`,toid from sqoop_solar_apolo_ques
Got it now! Thanks again for your help! guys!
2016-05-19 11:09 GMT+08:00 Heng Chen :
> Hi, guys.
>
> I write one example as @furcy said like this.
>
> public static void main(String[] args) throws SemanticException,
> ParseException, IOException {
> String sql =
oke(Method.java:497)
at com.intellij.rt.execution.application.AppMain.main(AppMain.java:144)
2016-05-19 10:20 GMT+08:00 Heng Chen :
> Thanks guys! Let me try it firstly.
>
> 2016-05-19 1:44 GMT+08:00 Pengcheng Xiong :
>
>> Hi Heng,
>>
>> Sure you can. Hive SQL pars
ny further help. Thanks.
>
> Best
> Pengcheng Xiong
>
> On Wed, May 18, 2016 at 3:43 AM, Heng Chen
> wrote:
>
>> Hi, guys.
>>
>> Recently, we need to integrate Hive SQL parser in our
>> application. Is there any way to do it?
>>
>> Thanks!
>>
>
>
Hi, guys.
Recently, we need to integrate Hive SQL parser in our application.
Is there any way to do it?
Thanks!
My company do ETL data flow using HIVE + Pig, it is OK now.
2016-02-16 14:55 GMT+08:00 Jörn Franke :
> Why should it not be ok if you do not miss any functionality? You can use
> oozie + hive queries to have more sophisticated logging and scheduling. Do
> not forget to do proper capacity/queu
it directly,
>
> not through beeline.
>
>
>
> On Tue, Dec 29, 2015 at 5:38 PM, Heng Chen
> wrote:
>
>> Have you try to set hive_aux_jars_path explicitly in beeline shell?
>> I found this problem too when i use hive-jdbc in my project, and i set
>> hive_aux_jars_p
Have you try to set hive_aux_jars_path explicitly in beeline shell?
I found this problem too when i use hive-jdbc in my project, and i set
hive_aux_jars_path explicitly in my code.
Hopes it will be helpful.
2015-12-29 15:58 GMT+08:00 Peyman Mohajerian :
> Maybe you need to also add:
>
> HIVE_A