Member since
09-24-2015
527
Posts
136
Kudos Received
19
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
1762 | 06-30-2017 03:15 PM | |
2453 | 10-14-2016 10:08 AM | |
7737 | 09-07-2016 06:04 AM | |
9351 | 08-26-2016 11:27 AM | |
1164 | 08-23-2016 02:09 PM |
05-31-2016
04:28 PM
hi: i think i need this jar, but i dont knwo why hive-shims-0.11.0.jar
... View more
05-31-2016
04:24 PM
HI: Hi , hibeserver is running hive 9704 3.3 0.7 2379760 376784 ? Sl 18:10 0:33 /usr/jdk64/jdk1.8.0_40/bin/java -Xmx8192m -Dhdp.version=2.4.0.0-169 -Djava.net.preferIPv4Stack=true -Dhdp.version=2.4.0.0-169 -Dhadoop.log.dir=/var/log/hadoop/hive -Dhadoop.log.file=hadoop.log -Dhadoop.home.dir=/usr/hdp/2.4.0.0-169/hadoop -Dhadoop.id.str=hive -Dhadoop.root.logger=INFO,console -Djava.library.path=:/usr/hdp/current/hadoop-client/lib/native/Linux-amd64-64:/usr/hdp/2.4.0.0-169/hadoop/lib/native -Dhadoop.policy.file=hadoop-policy.xml -Djava.net.preferIPv4Stack=true -Xmx8192m -Xmx512m -Dhadoop.security.logger=INFO,NullAppender org.apache.hadoop.util.RunJar /usr/hdp/2.4.0.0-169/hive/lib/hive-service-1.2.1000.2.4.0.0-169.jar org.apache.hive.service.server.HiveServer2 --hiveconf hive.aux.jars.path=file:///usr/hdp/current/hive-webhcat/share/hcatalog/hive-hcatalog-core.jar -hiveconf hive.metastore.uris= -hiveconf hive.log.file=hiveserver2.log -hiveconf hive.log.dir=/var/log/hive
... View more
05-31-2016
04:20 PM
Hi: after restarted it, the same error: H110 Unable to submit statement. java.lang.NoSuchMethodError: org.apache.hadoop.hive.shims.HadoopShims.setHadoopSessionContext(Ljava/lang/String;)V [ERROR_STATUS] I think that i lost some path or jar, but i just restart the process.
... View more
05-31-2016
03:50 PM
hi: I have restarte hive service and i cant use hive now, here the strange error, any suggestions?? i cant connect now to mysql hive database Connection failed on host lnxbig05.cajarural.gcr:10000 (Traceback (most recent call last): File "/var/lib/ambari-agent/cache/common-services/HIVE/0.12.0.2.0/package/alerts/alert_hive_thrift_port.py", line 200, in execute check_command_timeout=int(check_command_timeout)) File "/usr/lib/python2.6/site-packages/resource_management/libraries/functions/hive_check.py", line 68, in check_thrift_port_sasl timeout=check_command_timeout File "/usr/lib/python2.6/site-packages/resource_management/core/base.py", line 154, in __init__ self.env.run() File "/usr/lib/python2.6/site-packages/resource_management/core/environment.py", line 158, in run self.run_action(resource, action) File "/usr/lib/python2.6/site-packages/resource_management/core/environment.py", line 121, in run_action provider_action() File "/usr/lib/python2.6/site-packages/resource_management/core/providers/system.py", line 238, in action_run tries=self.resource.tries, try_sleep=self.resource.try_sleep) File "/usr/lib/python2.6/site-packages/resource_management/core/shell.py", line 70, in inner result = function(command, **kwargs) File "/usr/lib/python2.6/site-packages/resource_management/core/shell.py", line 92, in checked_call tries=tries, try_sleep=try_sleep) File "/usr/lib/python2.6/site-packages/resource_management/core/shell.py", line 140, in _call_wrapper result = _call(command, **kwargs_copy) File "/usr/lib/python2.6/site-packages/resource_management/core/shell.py", line 285, in _call raise ExecuteTimeoutException(err_msg) ExecuteTimeoutException: Execution of 'ambari-sudo.sh su ambari-qa -l -s /bin/bash -c 'export PATH='"'"'/usr/sbin:/sbin:/usr/lib/ambari-server/*:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/usr/dmexpress/bin:/home/bigotes/bin:/usr/dmexpress/bin:/var/lib/ambari-agent:/bin/:/usr/bin/:/usr/lib/hive/bin/:/usr/sbin/'"'"' ; ! beeline -u '"'"'jdbc:hive2://HOSTNAME:10000/;transportMode=binary'"'"' -e '"'"''"'"' 2>&1| awk '"'"'{print}'"'"'|grep -i -e '"'"'Connection refused'"'"' -e '"'"'Invalid URL'"'"''' was killed due timeout after 60 seconds ) thanks
... View more
Labels:
- Labels:
-
Apache Hive
05-26-2016
06:16 PM
Hi: How can i add Nifi or other services no officials into ambari??? Thanks
... View more
05-26-2016
05:41 PM
Hi: I change my decimal(9,2) in hive to Double, and now its working
... View more
05-26-2016
10:05 AM
Hi: I saw in apache drill that decimal is disabled, so, I activated from the command line: 0: jdbc:drill:> ALTER SYSTEM SET `planner.enable_decimal_data_type` = true;
+-------+--------------------------------------------+
| ok | summary |
+-------+--------------------------------------------+
| true | planner.enable_decimal_data_type updated. |
+-------+--------------------------------------------+
1 row selected (0.093 seconds)
and the query was done correctly encantos | 1 | 2016-04-02 | DVI82OOU | 3023 | 32.00 |
| banzhinan | 1 | 2016-04-02 | DVI82OOU | 3023 | 0.10 |
| labogran | 1 | 2016-04-02 | DVI82OOU | 3023 | 50.00 |
| nortegra | 15 | 2016-04-02 | DVI82OOU | 3023 | 483.40 |
+---------------------+------+-------------+-----------+------------+----------+
but from Rstudio and R, Doesnt work and iam receiving this error: oadd.org.apache.drill.exec.vector.accessor.InvalidAccessException: Requesting value of type long for an object of type DECIMAL9:OPTIONAL is not allowed. SO, I need to activate somenthing from R also??? Thanks
... View more
Labels:
- Labels:
-
Apache Hive
05-25-2016
07:08 PM
Hi: After try alot time is working with this: {
"type": "hive",
"enabled": true,
"configProps": {
"hive.metastore.uris": "thrift://hostname_metastore:9083",
"javax.jdo.option.ConnectionURL": "jdbc:mysql://hostname_metastore/drill",
"hive.metastore.warehouse.dir": "/tmp/drill_hive_wh",
"fs.default.name": "hdfs://master_hortonworks:8020",
"hive.metastore.sasl.enabled": "false"
}
}
... View more
05-25-2016
01:13 PM
Hi: I have copied it and runned this command and still doestn work. [root@lnxbig05 lib]# pwd
/opt/apache-drill-1.6.0/lib
[root@lnxbig05 lib]# ls -lrt
total 968
-rw-r--r-- 1 root root 989497 May 4 13:11 mysql-connector-java-5.1.39-bin.jar
script:
[root@lnxbig05 bin]# ./sqlline –u mysql:drill:schema=hiveremote;zk=lnxbig04.cajarural.gcr:2181,lnxbig05.cajarural.gcr:2181,lnxbig06.cajarural.gcr:2181
OpenJDK 64-Bit Server VM warning: ignoring option MaxPermSize=512M; support was removed in 8.0
–u (No such file or directory)
mysql:drill:schema=hiveremote (No such file or directory)
apache drill 1.6.0
"drill baby drill"
sqlline>
but i cant see that: jdbc:drill:schema=hiveremote> thanks
... View more
05-25-2016
12:40 PM
Hi: I cant connect to my HiveMetastore, here the file and the error: {
"type": "hive",
"enabled": true,
"configProps": {
"hive.metastore.uris": "",
"javax.jdo.option.ConnectionURL": "jdbc:mysql://hostname:10000/hive",
"hive.metastore.warehouse.dir": "/tmp/drill_hive_wh",
"fs.default.name": "file:///",
"hive.metastore.sasl.enabled": "false"
}
}
Error 14:38:42.335 [qtp2051611232-196] ERROR DataNucleus.Datastore.Schema - Failed initialising database.
org.datanucleus.exceptions.NucleusDataStoreException: Unable to open a test connection to the given database. JDBC url = jdbc:mysql://lnxbig05.cajarural.gcr:10000/hive, username = APP. Terminating connection pool (set lazyInit to true if you expect to start your database after your app). Original Exception: ------
java.sql.SQLException: No suitable driver found for jdbc:mysql://lnxbig05.cajarural.gcr:10000/hive
at java.sql.DriverManager.getConnection(DriverManager.java:689)
at sun.reflect.GeneratedConstructorAccessor179.newInstance(Unknown Source) ~[na:na]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) [na:1.8.0_65]
at java.lang.reflect.Constructor.newInstance(Constructor.java:422) [na:1.8.0_65]
at com.jolbox.bonecp.PoolUtil.generateSQLException(PoolUtil.java:192) ~[bonecp-0.8.0.RELEASE.jar:na]
at com.jolbox.bonecp.BoneCP.<init>(BoneCP.java:422) ~[bonecp-0.8.0.RELEASE.jar:na]
at com.jolbox.bonecp.BoneCPDataSource.getConnection(BoneCPDataSource.java:120) ~[bonecp-0.8.0.RELEASE.jar:na]
at org.datanucleus.store.rdbms.ConnectionFactoryImpl$ManagedConnectionImpl.getConnection(ConnectionFactoryImpl.java:501) ~[datanucleus-rdbms-3.2.9.jar:na]
... 92 common frames omitted
Caused by: java.sql.SQLException: No suitable driver found for jdbc:mysql://lnxbig05.cajarural.gcr:10000/hive
at java.sql.DriverManager.getConnection(DriverManager.java:689) ~[na:1.8.0_65]
at java.sql.DriverManager.getConnection(DriverManager.java:208) ~[na:1.8.0_65]
at com.jolbox.bonecp.BoneCP.obtainRawInternalConnection(BoneCP.java:361) ~[bonecp-0.8.0.RELEASE.jar:na]
at com.jolbox.bonecp.BoneCP.<init>(BoneCP.java:416) ~[bonecp-0.8.0.RELEASE.jar:na]
... 94 common frames omitted
... View more
Labels:
- Labels:
-
Apache Hive