hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Namit Jain <>
Subject Re: Hive Unit Tests: Read-Only Table
Date Tue, 12 Jun 2012 21:26:06 GMT
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