hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Shefali Vohra <>
Subject RE: Hive Unit Tests: Read-Only Table
Date Tue, 12 Jun 2012 21:53:40 GMT
Yep we solved our problem. Thank you so much!!


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

You can create new tables in .q files and then modify them.
The .q file should be self-contained.

On 6/12/12 2:19 PM, "Kanna Karanam" <> wrote:

>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 
>>>>Does anybody have a solution for this?
>>>> Thanks!
>>>> Shefali

View raw message