Re: Strange error in Hive - Insert INTO

2013-08-19 Thread Jérôme Verdier
8:43 AM To: user@hive.apache.org user@hive.apache.org Subject: Re: Strange error in Hive - Insert INTO Hi Jerome, That's a grandiose sql statement you got there! :)I find that if you break up those nested queries into simple CTAS (Create Table AS) statements and create a cascading

Strange error in Hive - Insert INTO

2013-08-14 Thread Jérôme Verdier
Hi everybody, I faced a strange error in Hive today. I have launch a hive script to make some calculations, joins, union, etc... and then insert these results in over hive table. Everything is working fine (.hql is working, full ok, data are imported), but one field (CO_RGRP_PRODUITS) is very

Re: Strange error in Hive - Insert INTO

2013-08-14 Thread Stephen Sprague
Hi Jerome, That's a grandiose sql statement you got there! :)I find that if you break up those nested queries into simple CTAS (Create Table AS) statements and create a cascading effect of referring to the table in the previous step it makes debugging *so* much easier. In other SQL dialects

Re: Strange error in Hive - Insert INTO

2013-08-14 Thread Sanjay Subramanian
@hive.apache.orgmailto:user@hive.apache.org user@hive.apache.orgmailto:user@hive.apache.org Date: Wednesday, August 14, 2013 8:43 AM To: user@hive.apache.orgmailto:user@hive.apache.org user@hive.apache.orgmailto:user@hive.apache.org Subject: Re: Strange error in Hive - Insert INTO Hi Jerome, That's