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" a écrit :
> Hi Lohith,
> We use http server. Lemme explain
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 :
> I would like to create a table in hive using Java. Using the foll
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 wrote:
I have used hive query to get column values that returns HiveResultSet. I
need to find Min and Max value in HiveResultSet in code level.
Is there any possibility. I am using c#.
-Renuka N
On Fri, Jul 31, 2015 at 3:29 AM, Nitin Pawar
wrote:
> then why not just use max function?
>
> select max(a
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
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 wrote:
> Hi Nitin,
>
> I am using hive query.
>
> Regards,
> Renuka N.
>
> On Fri, Jul 31, 2015 at 2:42 AM, Nitin Pawar
> wrote:
>
>> are you writing yo
It may be.
Problem is with text file formats, if the file has any special chars inside
and its not properly escaped, you end up in trouble.
In my case we always process the files before loading into a hive table
(especially for text data cause a simple new line in a csv file without a
proper csvre
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 prob
Hi Nitin,
I am using hive query.
Regards,
Renuka N.
On Fri, Jul 31, 2015 at 2:42 AM, Nitin Pawar
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
> wrote:
>
>> Hi Folks,
>>
>> I want to find Max value from the Hi
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 wrote:
> Hi Nithin,
> Thanks for replying.
> The select query runs like a charm, but only when insertion into a table,
> then thi
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
wrote:
> sorry but i could not find following info
> 1) are you using
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 fi
13 matches
Mail list logo
