The type String doesn't exist in SQL. I think you want to use VARCHAR
instead ;-)
Regards,
Loïc
Loïc CHANEL
Engineering student at TELECOM Nancy
Trainee at Worldline - Villeurbanne
2015-07-31 13:56 GMT+02:00 Sateesh Karuturi sateesh.karutu...@gmail.com:
I would like to create a table in hive
Hive is not really meant to serve data as fast as a web page needs. You'll
have to use some intermediate (could even be a db file, or template toolkit
generated static pages).
David
Le 28 juil. 2015 8:53 AM, siva kumar siva165...@gmail.com a écrit :
Hi Lohith,
We use http
Hi,
We are facing issue with our hive query with ArrayIndexoutofbound exception.
I have tried googling out and I see many users facing the same error, but
no solution yet. This is a blocker for our production and we really need
help on this.
We are using Hive version : 1.3.0.
Our query is doing
Hi Nithin,
Thanks for replying.
The select query runs like a charm, but only when insertion into a table,
then this problem occurs.
Please find the answers inline.
Thanks,
Ravi
On Fri, Jul 31, 2015 at 12:34 PM, Nitin Pawar nitinpawar...@gmail.com
wrote:
sorry but i could not find following
OK I will try it out,
I see this info log in the MR log, should this be a problem?
2015-07-31 11:27:47,487 INFO [main]
org.apache.hadoop.hive.serde2.lazybinary.LazyBinaryStruct: Missing fields!
Expected 14 fields but only got 7! Last field end 97 and serialize buffer
end 61. Ignoring similar
Hi Nitin,
I am using hive query.
Regards,
Renuka N.
On Fri, Jul 31, 2015 at 2:42 AM, Nitin Pawar nitinpawar...@gmail.com
wrote:
are you writing your java code using hive or you are writing hive query?
On Fri, Jul 31, 2015 at 11:13 AM, Renuka Be renunalin...@gmail.com
wrote:
Hi Folks,
I
sorry but i could not find following info
1) are you using tez as execution engine? if yes make sure its not snapshot
version
2) are you using orc file format? if yes then set flag to ignore corrupt
data
3) are there nulls on your join condition columns
if possible share the query and underlying
is there a different output format or the output table bucketed?
can you try putting a not null condition on join columns
On Fri, Jul 31, 2015 at 12:45 PM, ravi teja raviort...@gmail.com wrote:
Hi Nithin,
Thanks for replying.
The select query runs like a charm, but only when insertion into a
then why not just use max function?
select max(a) from (select sum(a) as a, b from t group by b)n
On Fri, Jul 31, 2015 at 12:48 PM, Renuka Be renunalin...@gmail.com wrote:
Hi Nitin,
I am using hive query.
Regards,
Renuka N.
On Fri, Jul 31, 2015 at 2:42 AM, Nitin Pawar
are you writing your java code using hive or you are writing hive query?
On Fri, Jul 31, 2015 at 11:13 AM, Renuka Be renunalin...@gmail.com wrote:
Hi Folks,
I want to find Max value from the HiveResult. There is option listed in
HiveResultSet properties HiveResultSet.Max(). When i use this
I would like to create a table in hive using Java. Using the following way
to do it:
public class HiveCreateTable {
private static String driverName = com.facebook.presto.jdbc.PrestoDriver;
public static void main(String[] args) throws SQLException {
// Register driver and create
why don't you get those as result of query results instead of iterating
through all on c# side?
your query can directly provide min and max
is there is a specific thing which is blocking you from getting from hive
and do it on application side?
On Fri, Jul 31, 2015 at 4:14 PM, Renuka Be
Hi,
I am using hive jdbc. I have a result set object, I want to navigate it in
forward and backward direction as well. By default result set behavior is
TYPE_FORWARD_ONLY. Why does hive jdbc does not have support for
setFetchDirection() method in ResultSet, to navigate result set object from
last
13 matches
Mail list logo