shankarpanda003

I am facing some little issue with JRS5.I have installed JRS on Redhat Linux environment. When i click on change password link it gives two field to enter password and confirm password(re type password) , but when i am giving two different values ,it does not show any error like password doesnt match and any thing like that. rather it changes the password as per the first filed value.

I ma using hive and mysql as metastore db.how can i connect to hive through ireport.When i am giving jdbc:hive://localhost:10000/default,,it is prompting as connection refused.irt was working file untill i had not used mysql as metastore for hive.Please suggest what to do.

Hi Matt...I am getting some problem. when i am running hive server from root i mean when my present working directory is root then only i am able to establish the connection between ireport and hive and also i am not able to execute any query in hive cli which runs in root directory but it runs if i start the hive cli from hive installed direcory.Please help where i am doing wrong?

Hive is running fine untill and unless hive connection established in ireport.when i am not connected to ireport ,i can create ,load and everything i can do in hive shell.But i connect to ireport ,i am getting error in hive shell.error is like hive> show tables;FAILED: Error in metadata: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClientFAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask Anyone has any idea about this?Thnaks for the help :)

Its solved. :)

Your database must have been there at cloud,so Its best practice to run iReport on cloud and compile your report there and upload the jrxml file directly onto the server or through iReport...

Hi Anu,Your aws is running on which platform ,i mean its windows or linux?there you must have installed jasperReport server.If u cant find ireport there u can download and run there.

My script is like this but i am not able to load the data successfully#!/bin/bash> bin/hive> load data local inpath '/usr/local/hadoop_dir/hadoop/input/sample.txt'> overwrite into table sample;> exit;[/code]can anyone help me on this?

I am using Hive-0.10.0.i have created a table account create table account(id int,city_id int,name string,address string) >row format delimited >fields terminated by ','; table is created successfully in hive and i have loaded the local csv file into that load data local 'path/account.csv' into table account; and i can also anle to see those records who has been created but when i am connecting to hive trough ireport and in the report query when i am writing select * from account,it says Error:error executing sql statement for null though it is showing correctly on hive cell. Please Help

Thanks Marianol. It is solved.Actually before connecting to hive from ireport,first i had to set the hive port=10000 and i should have to start the hiveserver.Thats why that error was coming.And yes it should be localhost instead of HOST

When I am giving localhost also,,it is saying connection refused.Dont know what to do.

My hadoop version is 1.1.1 and so i am using hadoop-0.9.0.I am not able to establish the connection to hive through ireport. iam getting this error.CCan anyone help me out?

Successfully done the installation of hadoop but while compiling hive getting this error repeatedly. Logging initialized using configuration in jar:file:/install/hive-0.8.0-bin/lib/hive-common-0.8.0.jar!/hive-log4j.properties Hive history file=/tmp/root/hive_job_log_root_201301092207_549512300.txt Exception in thread "main" java.lang.RuntimeException: org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.RuntimeException: java.lang.RuntimeException: Could not load shims in class null at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:277) at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:603) at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:554) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.hadoop.util.RunJar.main(RunJar.java:192) Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.RuntimeException: java.lang.RuntimeException: Could not load shims in class null at org.apache.hadoop.hive.ql.metadata.HiveUtils.getAuthenticator(HiveUtils.java:225) at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:270) ... 7 more Caused by: java.lang.RuntimeException: java.lang.RuntimeException: Could not load shims in class null at org.apache.hadoop.hive.ql.security.HadoopDefaultAuthenticator.setConf(HadoopDefaultAuthenticator.java:53) at org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:70) at org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:125) at org.apache.hadoop.hive.ql.metadata.HiveUtils.getAuthenticator(HiveUtils.java:222) ... 8 more Caused by: java.lang.RuntimeException: Could not load shims in class null at org.apache.hadoop.hive.shims.ShimLoader.createShim(ShimLoader.java:102) at org.apache.hadoop.hive.shims.ShimLoader.loadShims(ShimLoader.java:94) at org.apache.hadoop.hive.shims.ShimLoader.getHadoopShims(ShimLoader.java:65) at org.apache.hadoop.hive.ql.security.HadoopDefaultAuthenticator.setConf(HadoopDefaultAuthenticator.java:51) ... 11 more Caused by: java.lang.NullPointerException at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:169) at org.apache.hadoop.hive.shims.ShimLoader.createShim(ShimLoader.java:99) ... 14 more Can anyone suggest me on this.

[java] Creating ActionModelService object. [java] Creating action model infrastructure. [java] Creating action model infrastructure. [java] Creating action model infrastructure. BUILD FAILED/usr/games/jasperreports-server-cp-4.7.0-bin/buildomatic/bin/db-common.xml:759: The following error occurred while executing this line:/usr/games/jasperreports-server-cp-4.7.0-bin/buildomatic/bin/import-export.xml:270: The following error occurred while executing this line:/usr/games/jasperreports-server-cp-4.7.0-bin/buildomatic/bin/import-export.xml:158: Java returned: 137 if anyone has came across it or anyone do have idea,,please help me

i am also facing the same problem.how did u resolve that.can u tell briefly?