Error in semantic analysis: Lock manager could not be initialized

here is my hive config file,i do not know why,anyone can help? property namejavax.jdo.option.ConnectionURL/name valuejdbc:mysql://192.168.10.118/metastore/value descriptionthe URL of the MySQL database/description /property property namejavax.jdo.option.ConnectionDriverName/name

Re: export csv, use ',' as split

hive create table is different than the hive query output, hive by default uses tab as output column separator on console. if you want to change to csv, why don't you just use sed and replace tab with , if you want a csv generated out of the query itself then create a temporary external table

Re: can not connect hive through jdbc

Can you tell use which jdbc version are you using? and try changing it to jdbc:hive from jdbc:hive2 On Wed, Jul 10, 2013 at 12:34 PM, ch huang justlo...@gmail.com wrote: i use following java code import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet;

Re: can not connect hive through jdbc

yes i try ,and i get Invalid URL error Exception in thread main java.sql.SQLException: Invalid URL: jdbc:hive2:// 192.168.10.22:1/default at org.apache.hadoop.hive.jdbc.HiveConnection.init(HiveConnection.java:85) at org.apache.hadoop.hive.jdbc.HiveDriver.connect(HiveDriver.java:104) at

start hive2 error

i try start hiveserver2 ,buy error in log file ,why ? i use hive 0.10 2013-07-10 14:18:31,821 WARN hive.metastore (HiveMetaStoreClient.java:open(285)) - Failed to connect to the MetaStore Server... 2013-07-10 14:18:32,830 ERROR service.CompositeService (CompositeService.java:start(74)) - Error

Re: start hive2 error

hello, verify if ZooKeeper is running on port 2181 (not on port 2281 like you have in Hive-site.xml) if changing port don't work assure that your Zookeeper quorum is listining on port 2281. 2013/7/10 ch huang justlo...@gmail.com i try start hiveserver2 ,buy error in log file ,why ? i use hive

Using INDEX inside SUBSTR

Hi All, One of my Teradata query is SUBSTR(PRESG_ID,INDEX(PRESG_ID,' ')+1,1) IN ('1','2','3') Any idea of the above to convert to hive, It seems to be a simple qus but am stuck...didn't get a chance to try it out in cluster :( -Thanks

Re: Using INDEX inside SUBSTR

rather than us just do the work for you show us your attempts to solve this. hint: did you look at this page? https://cwiki.apache.org/Hive/languagemanual-udf.html#LanguageManualUDF-StringFunctions On Wed, Jul 10, 2013 at 5:06 AM, dyuti a hadoop.hiv...@gmail.com wrote: Hi All, One of my

Re: export csv, use ',' as split

Hive does not have a output delimiter specifier yet (not sure if 0.11.x may have it) But for now please try the following hive -e myquery | sed 's/\t/,/g' result.csv Good luck Sanjay From: kentkong_work kentkong_w...@163.commailto:kentkong_w...@163.com Reply-To:

hive jdbc exception

Hi all, I am trying to execute a hiveql query from a java application with connection string jdbc:hive://localhost:1 but I get org.apache.transport.TTransportException. Have anyone faced this problem to give me a solution? Thanks

Re: hive jdbc exception

obvious question first. is your Hive Server running on port 1?to check: $ netstat -lanp | grep 1 (might need to run as root. show us the output) On Wed, Jul 10, 2013 at 1:04 PM, Κωνσταντίνος Αρετάκης kareta...@gmail.comwrote: Hi all, I am trying to execute a hiveql query from

Re: hive jdbc exception

Thanks! It was the server not able to run at the default port 1! I did netstat and I saw a service running at 1 port and thought it was the hive server but it wasnt! I changed the port and it worked! Thanks again! K.A On 10 Ιουλ 2013, at 23:30, Stephen Sprague sprag...@gmail.com wrote:

Re: Oracle to Hive

Untested: SELECT a.c100, a.c300, b.c400   FROM t1 a   JOIN t2 b   ON a.c200 = b.c200   JOIN (SELECT DISTINCT a.c100           FROM t1 a2           JOIN t2 b2           ON a2.c200 = b2.c200         WHERE b2.c400 = SYSDATE - 1) a3   ON a.c100 = a3.c100   WHERE b.c400 = SYSDATE - 1    AND a.c300 = 0

Re: export csv, use ',' as split

Fixed in hive-0.11.0 https://issues.apache.org/jira/browse/HIVE-3682 2013/7/11 Sanjay Subramanian sanjay.subraman...@wizecommerce.com: Hive does not have a output delimiter specifier yet (not sure if 0.11.x may have it) But for now please try the following hive -e myquery | sed 's/\t/,/g'

Re: HBase -- Hive / HCatalog -- PIG

Hi Rajesh, You might be interested in HIVE-4331 for the Pig integration. I think Viraj had tested this entire use case on a secure cluster. -Thiruvel From: Rajesh Balamohan rajesh.balamo...@gmail.commailto:rajesh.balamo...@gmail.com Reply-To: user@hive.apache.orgmailto:user@hive.apache.org

lot's of deprecated info in hive metastore log

i do not know why ,i have no mapred.reduce.tasks option defined in config file,anyone can help? hive-metastore.log:2013-07-10 10:10:34,890 WARN conf.Configuration (Configuration.java:warnOnceIfDeprecated(824)) - mapred.reduce.tasks.speculative.execution is deprecated. Instead, use

Re: HBase -- Hive / HCatalog -- PIG

Thanks a lot Thiruvel. I will look into the JIRA. ~Rajesh.B On Thu, Jul 11, 2013 at 7:09 AM, Thiruvel Thirumoolan thiru...@yahoo-inc.com wrote: Hi Rajesh, You might be interested in HIVE-4331 for the Pig integration. I think Viraj had tested this entire use case on a secure cluster.

HiveServer2 JDBC Client- [Multithreaded connection]

Hi, I am attempting to create a JDBC Client to HiveServer2. I have set the following property to support concurrency property namehive.support.concurrency/name descriptionEnable Hive's Table Lock Manager Service/description valuetrue/value /property The JDBC client spawns multiple