hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kanna Karanam <>
Subject RE: Hive Unit Tests: Read-Only Table
Date Tue, 12 Jun 2012 21:19:25 GMT
Hi Namit, If I understand correctly, she wants to create a new table (Not modifying the existing
tables) as part of the test setup to validate her new UDFs. Are there any guidelines on where
to create new tables with different data to validate new UDFs?


-----Original Message-----
From: Namit Jain [] 
Sent: Tuesday, June 12, 2012 2:13 PM
Subject: Re: Hive Unit Tests: Read-Only Table

You cannot change tables which are created by QTestUtil (like src).

On 6/12/12 12:34 PM, "Shefali Vohra" <> wrote:

>Fair enough. So (just to make sure) if I need to create a table to run 
>a test, I should do so within the .q file itself?
>Thanks so much for your help!!
>-----Original Message-----
>From: Edward Capriolo []
>Sent: Tuesday, June 12, 2012 12:30 PM
>Subject: Re: Hive Unit Tests: Read-Only Table
>As mentioned we normally do not touch the 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 <>
>> Sorry I think my original message was a bit ambiguous and I think my 
>>error 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 
>>, however I'm getting the read-only error I described 
>>earlier. Do you know how to solve this problem?
>> Thank you!
>> Shefali
>> -----Original Message-----
>> From: Edward Capriolo []
>> Sent: Tuesday, June 12, 2012 12:01 PM
>> To:
>> Subject: Re: Hive Unit Tests: Read-Only Table
>> It seems like your are running unit tests in a non-standard way. It 
>>sounds like your are trying to write stand along j-unit tests. Hive 
>>uses velocity to turn .q scripts into test and the testing framework 
>>diffs the output.
>> You should look at the .q files inside 
>> src/ql/test/clientpositive/whatever.q
>> Or give this a go (its a unit testing tool I wrote):
>> On Tue, Jun 12, 2012 at 1:47 PM, Shefali Vohra 
>>> 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.  When I 
>>>try to run it though, I get the error "Cannot overwrite read-only table."
>>>Does anybody have a solution for this?
>>> Thanks!
>>> Shefali

View raw message