Member since
04-22-2016
931
Posts
46
Kudos Received
26
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
1486 | 10-11-2018 01:38 AM | |
1853 | 09-26-2018 02:24 AM | |
1809 | 06-29-2018 02:35 PM | |
2396 | 06-29-2018 02:34 PM | |
5338 | 06-20-2018 04:30 PM |
02-26-2019
01:01 AM
@Sami Ahmad You are adding "hadoop classpath" however you will also need to add "hbase classpath" something like following: # javap -cp `hadoop classpath`:`hbase classpath`:.: TestHbaseTable.java .
... View more
11-27-2018
06:00 PM
1 Kudo
@Sami Ahmad For Knox , you have to make 2 curl calls. The second curl call should be made to the "Location" header obtained from the 1st curl call response. 1st curl call curl -i -k -u admin:admin-password -X GET 'https://localhost:8443/gateway/default/webhdfs/v1/tmp/uname.txt?op=OPEN'
HTTP/1.1 307 Temporary Redirect
Date: Tue, 27 Nov 2018 16:21:44 GMT
Set-Cookie: JSESSIONID=1219u2f8zreb11eu9fuxlggxhq;Path=/gateway/default;Secure;HttpOnly
Expires: Thu, 01 Jan 1970 00:00:00 GMT
Set-Cookie: rememberMe=deleteMe; Path=/gateway/default; Max-Age=0; Expires=Mon, 26-Nov-2018 16:21:44 GMT
Cache-Control: no-cache
Expires: Tue, 27 Nov 2018 16:21:44 GMT
Date: Tue, 27 Nov 2018 16:21:44 GMT
Pragma: no-cache
Expires: Tue, 27 Nov 2018 16:21:44 GMT
Date: Tue, 27 Nov 2018 16:21:44 GMT
Pragma: no-cache
X-FRAME-OPTIONS: SAMEORIGIN
Location: https://hadoop1:8443/gateway/default/webhdfs/data/v1/webhdfs/v1/tmp/uname.txt?_=AAAACAAAABAAAACgLvtILkFAljr5PIP7MVSOAump8j0kSwFCPdGCP2R_b1tCZ0V2KGOQuiRiI4_IU7GDG6NqRtK2Vu7DOZeOhbuQUaP1FYtD_-IV3P-VXMbOFbPfbwpNseAuN-RyQduRm5S1mrk0GVbYKQg4NscgsoF0GGsvqKDyPtECwhwkX96E37Jc5_yCnlkw3LVKUY41Hg6LOt96W8-3rTmnrbo7o26dOcpPv1_uv4Q1F18b4yk5N5BNf6HTZdVZ6Q
Content-Type: application/octet-stream
Server: Jetty(6.1.26.hwx)
Content-Length: 0
2nd curl call (url is taken from Location header obtained in 1st curl call) curl -i -k -u admin:admin-password -X GET https://hadoop1:8443/gateway/default/webhdfs/data/v1/webhdfs/v1/tmp/uname.txt?_=AAAACAAAABAAAACgLvtILkFAljr5PIP7MVSOAump8j0kSwFCPdGCP2R_b1tCZ0V2KGOQuiRiI4_IU7GDG6NqRtK2Vu7DOZeOhbuQUaP1FYtD_-IV3P-VXMbOFbPfbwpNseAuN-RyQduRm5S1mrk0GVbYKQg4NscgsoF0GGsvqKDyPtECwhwkX96E37Jc5_yCnlkw3LVKUY41Hg6LOt96W8-3rTmnrbo7o26dOcpPv1_uv4Q1F18b4yk5N5BNf6HTZdVZ6Q
... View more
10-23-2018
04:49 AM
Why don't you try with string argument like this?
hive>select qp("hello");
... View more
10-14-2018
03:01 AM
can you give me an example on how to use the index after creation ? I am seeing all kinds of strange things just to use the index , don't know if its valid for hive 1.2.1 http://mail-archives.apache.org/mod_mbox/hive-user/201205.mbox/%3C60367909.283357.1337221656873.JavaMail.root@sms-zimbra-message-store-03.sms.scalar.ca%3E
... View more
10-15-2018
06:26 AM
Bucketed tables allows much more efficient sampling than non-bucketed tables. With sampling, we can try out queries on a section of data for testing and debugging purpose when the original data sets are very huge. False positive is possible on clustered by columns, whereas applying filters on partition column is better in pruning the exact files. Bucketing tables also helps in map-join, assuming the data is equally distributed. As it eliminates the cost of partitioning the data while joining. Bucketing is useful with high cardinality columns, as it reduces number of small files & clusters them within specified buckets. Earlier to HIVE-11525, bucketing wasn't able to filter files if multiple columns are clustered by.
... View more
10-11-2018
01:38 AM
ok i found the answer on apache site , starting hive 0.13 both syntax are supported . https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Joins
... View more
10-10-2018
06:18 PM
@Sami Ahmad, You can run the below command set; For ex: If you want to check the params that are set to true, then you can run hive -e 'set;' | grep true . -Aditya
... View more
10-03-2018
01:14 PM
You can not create the jar from hive view you will need to create it using java IDE i.e. eclipse or through command line tools I have shared you the video which explains you on how to create UDF jar file you can refer that video tutorial https://www.youtube.com/watch?v=BDbMPfNw_Tc
... View more