Member since
03-07-2019
322
Posts
17
Kudos Received
9
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
202 | 07-31-2024 11:57 AM | |
1608 | 03-27-2019 04:52 AM | |
6197 | 11-21-2018 10:21 PM | |
12548 | 09-14-2016 07:35 PM | |
10610 | 07-01-2016 06:56 PM |
09-12-2018
06:58 PM
1 Kudo
@n c its because that TBLPROPERTIES should the last one, use the below and it should help: +++++++++++++++++ CREATE EXTERNAL TABLE staging3 ROW FORMAT SERDE 'org.apache.hadoop.hive.serd2.avro.AvroSerDe' STORED AS INPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerInputFormat' OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerOutputFormat' LOCATION '/tmp/staging' TBLPROPERTIES ('avro.schema.url'='hdfs:///tmp/avroschemas/testtbl.json'); +++++++++++++++++
... View more
03-22-2018
03:42 PM
@Carol Elliott, I think the issue is related to the jt400.jar which is launching java awt windows to lauch a pop-up for login. I don't this this would work for you in this case. As you are connecting to DB2, I would suggest to use DB2 JDBC driver for ISeries, specifically these two jars: Type 4 JDBC driver: db2jcc4.jar and a license file: db2jcc_license_*xxx* .jar. IBM article link which talks about the same: http://www-01.ibm.com/support/docview.wss?uid=swg21959125
... View more
03-21-2018
11:54 PM
@Carol Elliott May be you can try using this option to see if this works: f you're on the main display, then export DISPLAY=:0.0 or if you're using csh or tcsh setenv DISPLAY :0.0
... View more
08-10-2017
09:26 PM
@sai harshavardhan The value that you are receiving is as expected, this sample java code show the info. If you are wanting to get the exact value as an output, you should convert that value to string. import java.lang.*; public class DoubleDemo { public static void main(String[] args) { double d = 12345678910.231; System.out.println("Value of d = " + d); } }
... View more
02-14-2017
07:00 PM
@bsaini Hive always takes timezone into consideration. May be what you want to try is to set that field as String which will retain the same value.
... View more
02-09-2017
10:24 PM
@Shashant Panwar Here is the link which talks about the HDFS quota. http://hadoop.apache.org/docs/r2.7.2/hadoop-project-dist/hadoop-hdfs/HdfsQuotaAdminGuide.html -Mahesh
... View more
02-09-2017
09:36 PM
@Shashant Panwar I dont understand the usecase of limiting a database to use a X percent. Lets assume you have a table which needs more than 25% of the disk space then you wont be able to do anything unless you delete and free up the space on that DB to allow data into the table. Also one cannot set limitation at Hive level to state how much space a database can use. It needs to be set at HDFS user level quota. -Mahesh
... View more
09-28-2016
06:50 PM
The reason this exception comes because that the Pig needs a local Tez client, if its not available then this exception is thrown even though the tez.lib.uris is present and the hdfs has the tez.tar.gz under correct hdp release.
... View more
09-14-2016
07:35 PM
@Sonny Heer Can you do this to see if the table does exist in hive. hive -e 'use mydb; show tables;' and see if this lists the table test1. If not then this would state why you are seeing the exception.
... View more
07-01-2016
07:26 PM
@suresh krish Yes, you will not be able to set this at runtime unless you have included that in the whitelist until this is done and you have restarted hive service along with HiveServer2 this would not take effect.
... View more