help with beeline connection to hive

Hello I have hive 2.3.9 installed by default on localhost for testing. HDFS is also installed on localhost, which works correctly b/c I have already used the file storage feature. I didn't change any configure files for hive. I can login into hive shell: hive> show databases; OK default Time

Re: help with beeline connection to hive

damage or destruction of data or any other property which may >> arise from relying on this email's technical content is explicitly >> disclaimed. The author will in no case be liable for any monetary damages >> arising from such loss, damage or destruction. >> >> >&

question about a beeline variable

what does this -1 value mean? > set mapred.reduce.tasks; +-+ | set | +-+ | mapred.reduce.tasks=-1 | +-+ 1 row selected (0.014 seconds)

Re: question about a beeline variable

I got the idea it's the null value in Hive. 0: jdbc:hive2://localhost:1/default> select size(null); +--+ | _c0 | +--+ | -1 | +--+ Thanks On Sun, Feb 27, 2022 at 4:02 PM Bitfox wrote: > what does this -1 value mean? > > > set

protobuf.ServiceException

Hello In beeline I am getting the error: 0: jdbc:hive2://localhost:1/default> select * from people; Error: java.io.IOException: java.io.IOException: com.google.protobuf.ServiceException: java.lang.NoSuchFieldError: PARSER (state=,code=0) Apache Hive (version 2.3.9) Hadoop 3.3.1 $ prot

Re: protobuf.ServiceException

guess that's where your problem lies. > > On Thu, 2022-03-10 at 06:57 +0800, Bitfox wrote: > > Hello > > In beeline I am getting the error: > > 0: jdbc:hive2://localhost:1/default> select * from people; > > Error: java.io.IOException: java.io.IOExcep

Hive 3 and Java 11 issue

my java version: openjdk version "11.0.13" 2021-10-19 I can't run hive 3.1.2. The error include: Exception in thread "main" java.lang.ClassCastException: class jdk.internal.loader.ClassLoaders$AppClassLoader cannot be cast to class java.net.URLClassLoader (jdk.internal.loader.ClassLoaders$App

Re: Hive 3 and Java 11 issue

That sounds bad. All our apps are running on JDK 11. On Thu, Mar 10, 2022 at 5:06 PM Pau Tallada wrote: > I think only JDK8 is supported yet > > Missatge de Bitfox del dia dj., 10 de març 2022 a les > 2:39: > >> my java version: >> >> openjdk version "11

Hive 3 with tez issue

"1.8.0_321" All of them were installed in a local node for development purposes. Please help with this issue. Thanks. Bitfox

Re: Hive 3 with tez issue

Or, is there a standard installation guide for integration tez and hive3? Thank you. On Mon, Mar 28, 2022 at 12:21 PM Bitfox wrote: > When I had this config in hive-env.sh: > > export > HADOOP_CLASSPATH=/opt/tez/conf:/opt/tez/*:/opt/tez/lib/*:$HADOOP_CLASSPATH > > > > a

out of memory error

My hive run out of memory even for a small query: 2022-03-29T20:26:51,440 WARN [Thread-1329] mapred.LocalJobRunner: job_local300585280_0011 java.lang.Exception: java.lang.OutOfMemoryError: Java heap space at org.apache.hadoop.mapred.LocalJobRunner$Job.runTasks(LocalJobRunner.java:492) ~[hadoop-

Re: out of memory error

l gets the same error. please help. thanks. On Tue, Mar 29, 2022 at 8:32 PM Pau Tallada wrote: > I assume you have to increase container size (if using tez/yarn) > > Missatge de Bitfox del dia dt., 29 de març 2022 a les > 14:30: > >> My hive run out of memory even for a small

Re: out of memory error

Yes, a quite small table with 1 rows for test purposes. Thanks On Tue, Mar 29, 2022 at 8:43 PM Pau Tallada wrote: > Hi, > > I think it depends a lot on the data volume you are trying to process. > Does it work with a smaller table? > > Missatge de Bitfox del dia dt., 29

Re: out of memory error

too tiny. Hadoop ecosystem is usually > memory-intensive > > Missatge de Bitfox del dia dt., 29 de març 2022 a les > 14:46: > >> Yes, a quite small table with 1 rows for test purposes. >> >> Thanks >> >> On Tue, Mar 29, 2022 at 8:43 PM Pau Tallada wrote: