Mailing-List: contact dev-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hive.apache.org
Received-SPF: pass (athena.apache.org: domain of t-shevo@microsoft.com
 designates 213.199.154.206 as permitted sender)
Received-SPF: pass (mail28-am1: domain of microsoft.com designates
 131.107.125.8 as permitted sender) client-ip=131.107.125.8;
 envelope-from=t-shevo@microsoft.com;
 helo=TK5EX14HUBC107.redmond.corp.microsoft.com ;icrosoft.com ;
From: Shefali Vohra <t-shevo@microsoft.com>
To: "dev@hive.apache.org" <dev@hive.apache.org>
Subject: RE: Hive Unit Tests: Read-Only Table
Thread-Topic: Hive Unit Tests: Read-Only Table
Thread-Index: Ac1IwpcO1YYXad9xSu261bchajJBMAACy2yAAACfpUAAAGEaAAAAGgXw
Date: Tue, 12 Jun 2012 19:34:27 +0000
Message-ID: 
 <C9D1CC1454EC0F4895F0EF8B1898698EA21EC1@TK5EX14MBXC252.redmond.corp.microsoft.com>
References: 
 <C9D1CC1454EC0F4895F0EF8B1898698EA21967@TK5EX14MBXC252.redmond.corp.microsoft.com>
	<CAENxBwww8tR6xEA-Jy+MKgeYJoiBs2nSCB3j=oy0hYcHpmA-Vg@mail.gmail.com>
	<C9D1CC1454EC0F4895F0EF8B1898698EA21E5D@TK5EX14MBXC252.redmond.corp.microsoft.com>
 <CAENxBwyL9vHPhXBDekU912xLfHqcFZLq3NFvxFitMgStRA6hEg@mail.gmail.com>
In-Reply-To: 
 <CAENxBwyL9vHPhXBDekU912xLfHqcFZLq3NFvxFitMgStRA6hEg@mail.gmail.com>
Accept-Language: en-US
Content-Language: en-US
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0

Fair enough. So (just to make sure) if I need to create a table to run a te=
st, I should do so within the .q file itself?=20

Thanks so much for your help!!
Shefali

-----Original Message-----
From: Edward Capriolo [mailto:edlinuxguru@gmail.com]=20
Sent: Tuesday, June 12, 2012 12:30 PM
To: dev@hive.apache.org
Subject: Re: Hive Unit Tests: Read-Only Table

As mentioned we normally do not touch the QTestUtil.java and instead do all=
 the work in q files. The only thing I can thing of is that the table name =
is bad or that you are overwriting and already existing table.

It is hard to tell without any code.

On Tue, Jun 12, 2012 at 3:24 PM, Shefali Vohra <t-shevo@microsoft.com> wrot=
e:
> Sorry I think my original message was a bit ambiguous and I think my erro=
r is a little different than what it may have implied.
> From what I understand, the *.q files contain Hive queries such as select=
 * from table, etc. I am creating that table within QTestUtil.java, however=
 I'm getting the read-only error I described earlier. Do you know how to so=
lve this problem?
>
> Thank you!
> Shefali
>
> -----Original Message-----
> From: Edward Capriolo [mailto:edlinuxguru@gmail.com]
> Sent: Tuesday, June 12, 2012 12:01 PM
> To: dev@hive.apache.org
> Subject: Re: Hive Unit Tests: Read-Only Table
>
> It seems like your are running unit tests in a non-standard way. It sound=
s like your are trying to write stand along j-unit tests. Hive uses velocit=
y to turn .q scripts into test and the testing framework diffs the output.
>
> You should look at the .q files inside=20
> src/ql/test/clientpositive/whatever.q
>
> Or give this a go (its a unit testing tool I wrote):
>
> https://github.com/edwardcapriolo/hive_test
>
>
> On Tue, Jun 12, 2012 at 1:47 PM, Shefali Vohra <t-shevo@microsoft.com> wr=
ote:
>> Hi!
>> I'm trying to add unit tests to a UDF I developed, and used the commands=
 runCreateTableCmd and runLoadCmd to create and load the table. I'm fairly =
certain it is loading from the correct filepath. =A0When I try to run it th=
ough, I get the error "Cannot overwrite read-only table." Does anybody have=
 a solution for this?
>>
>> Thanks!
>> Shefali
>
>