aised a ticket in sqoop jira [SQOOP-2840] for this .
>
> Thanks
> Biswa
>
>
>
>
>
> On Tue, Mar 1, 2016 at 9:56 AM, Richa Sharma
> wrote:
>
>> Hi,
>>
>> The values should still persist if partition column data type in Hive is
>> a string.
&g
ut how to handle the columns with INT type. Changing
> the type will be the last option for me.
>
> Regards
> Biswa
>
>
>
> On Tue, Mar 1, 2016 at 9:31 AM, Richa Sharma
> wrote:
>
>> Hi Biswajit
>>
>> The answer is in the last line of the error message.
Hi Biswajit
The answer is in the last line of the error message. Change the data type
of partition column to string in hive and try again.
Hope it helps !
Richa
16/02/12 08:04:12 ERROR tool.ExportTool: Encountered IOException
running export job: java.io.IOException: The table provided
default.e
Hi Divya
Below are some quick tips that always helps:
1. Partition your data set and use partition keys while selecting data to
reduce data set.
2.Also, if both data sets can be joined by the same partition key then use
it in the join.
3. If one table being joined is a small table then you can
Hi
Have a look at link below. They have enough examples to clarify usage
https://cwiki.apache.org/confluence/display/Hive/Tutorial#Tutorial-Joins
Richa
On Fri, Jul 26, 2013 at 1:47 PM, Ramasubramanian Narayanan <
ramasubramanian.naraya...@gmail.com> wrote:
> Hi,
>
> Need to create a view in H
> This query is working, it gives me results.
>
> You say that maybe i'm hitting the same bug of JIRA HIVE-4663, but query
> is also failling when i put analytical columns in...
>
>
> 2013/7/17 Richa Sharma
>
>> Vijay
>>
>> Jerome has already passed column
>> least 1 group must only depend on input columns. Also check for circular
>> dependencies.
>>
>> Underlying error:
>> org.apache.hadoop.hive.ql.exec.UDFArgumentTypeException: One or more
>> arguments are expected.
>> SQLState: 42000
>> ErrorCode: 4
>>
>>
>>
>>
>>
>
> GROUP BY
> mag.co_magasin,
> dem.id_produit,
> pnvente.dt_debut_commercial,
> COALESCE(pnvente.id_produit,dem.id_produit);
>
>
> 2013/7/16 Richa Sharma
>
>> Can you share query with just RANK().
>>
>> Richa
>>
>
Can you share query with just RANK().
Richa
On Tue, Jul 16, 2013 at 6:08 PM, Jérôme Verdier
wrote:
> Hi Richa,
>
> I tried to execute the rank function alone, but the result is the same
>
> Thanks
>
>
> 2013/7/16 Richa Sharma
>
>> Hi Jerome
>>
>>
Hi Jerome
I think the problem is you are trying to use MIN, SUM and RANK function in
a single query.
Try to get the rank first in a query and on top of it apply these aggregate
functions
Richa
On Tue, Jul 16, 2013 at 2:15 PM, Jérôme Verdier
wrote:
> Hi,
>
> I have a problem while using RAN
Do you have any timestamp fields in the table that might contain null value
?
I faced a similar situation sometime back - changing the data type to
string made it work.
But I was working on delimited text files.
Not sure if it applies to JSON .. but its still worth giving a try !!
Richa
On We
Hi
I am working on Hive version hive-service-0.10.0-cdh4.2.1
>From the manual it is clear that Date datatype is not yet supported but
timestamps are supported.
I am having trouble populating timestamp fields.
Tried 2 scenarios
1. Created a table with 1 column as timestamp field and loaded data
>> Name Server:
>> Name Server:
>> Name Server:
>> Name Server:
>> Name Server:
>> Name Server:
>>
>>
>> From: Dean Wampler
>> Reply-To: "user@hive.apache.org"
>> Date: Tuesday, June 11, 2013 11:04 AM
>> To: "
Hi all,
Found a very useful guide online. Link -> http://it-ebooks.info/book/941/
Richa
On Tue, Jun 11, 2013 at 1:53 PM, Richa Sharma
wrote:
> Thanks for sharing!
>
> I looked at these links .. Is there any documentation with more examples
> with both static and dynamic par
Thanks for sharing!
I looked at these links .. Is there any documentation with more examples
with both static and dynamic partitions covered together.
Richa
On Tue, Jun 11, 2013 at 12:33 PM, Lefty Leverenz wrote:
> Dynamic partitions are described in the Hive design docs here:
> https://cwiki.
Hi,
Can you please point to documentation on Dynamic partitioning.
I dont fully understand meaning of values for these parameters.
Regards
Richa
On Mon, Jun 10, 2013 at 7:08 PM, Nitin Pawar wrote:
> If a table is not partitioned and then you want to partition the table on
> the data already
Hi
Can i control the actual file name in which data is stored in an external
table in Hive ?
In Hive I want to load data from table A into an external table B and then
using Pig access data in table B.
Right now data is stored in file name 0_0 -- I want to give it a
definite way. is there a
17 matches
Mail list logo
