Re: iso 8601 to utc with timezone conversion

2016-09-23 Thread Sékine Coulibaly
Manish, UTC is not a format (but, ISO 8601 is). Consider UTC as + at the end of a ISO 8601 time. Eg: 2016-01-01T*23:45:22.943762*+ is stricylt equivalent to : 2016-01-01T*23:45:22.943762Z* *and is also strictly equivalent to the same time expressed in another timezone such as

Re: Hive insert into RCFILE issue with timestamp columns

2013-03-06 Thread Sékine Coulibaly
Prasad, Isn't the fractional part of the TIMESTAMP type supposed to be optional, as per the error message : Failed with exception java.io.IOException:java.lang.IllegalArgumentException: Timestamp format must be -mm-dd hh:mm:ss[.f] Shall we understand 9 digits for fractional part are

Re: Best table storage for analytical use case

2013-03-06 Thread Sékine Coulibaly
and joins. I assume you're just using the virtual machine for experimenting. Lots of overhead there, too! Hope this helps. dean On Mon, Mar 4, 2013 at 4:33 PM, Sékine Coulibaly scoulib...@gmail.comwrote: Hi there, I've setup a virtual machine hosting Hive. My use case is a Web traffic

Best table storage for analytical use case

2013-03-04 Thread Sékine Coulibaly
Hi there, I've setup a virtual machine hosting Hive. My use case is a Web traffic analytics, hence most of requests are : - how many requests today ? - how many request today, grouped by country ? - most requested urls ? - average http server response time (5 minutes slots) ? In other words,

Unable to issue count(*) query versus movielens data

2012-12-16 Thread Sékine Coulibaly
Hi there, I loaded data from the movielens database into hive, into a u_data table. I wish I could count the total number of rows in that table. Although mapreduce task starts, it ends with a Null Pointer Exception. I must admit I don't know what to do next, how to investigate this issue. The