Member since
02-06-2018
47
Posts
6
Kudos Received
0
Solutions
11-26-2021
04:28 AM
@nikkie_thomas You can set below if you are using Tez set hive.merge.mapfiles=true; set hive.merge.mapredfiles=true; set hive.merge.smallfiles.avgsize=<some value>; set hive.merge.size.per.task=<some value>; set hive.merge.tezfiles=true;
... View more
01-18-2019
10:51 PM
not exactly, as I mentioned state could either be started or installed only. I was to see if service is facing any issue,
... View more
10-04-2018
11:54 AM
Statistics estimation is approximated based on available stats. In your case, i see basic stats are collected, but column stats are not collected. To estimate the number of distinct values for a column, can you run analyze table temp.test_distinct compute statistics for columns; and check explain plan.
... View more
08-13-2018
07:10 PM
I found the solution, so posting here. The problem I was having is I was just stopping the docker container after making change in the command I was using to start the HDP image, didn't realize need to remove container as well. Following command helped. Save docker Work docker commit <hdp_container_id> <hdp_container_id> Stop and Remove docker. docker stop <hdp_container_id>
docker rm <hdp_container_id> Open 9083 port (hive metastore) by modifying start-sandbox-hdp-standalone_2-6-4.sh #!/bin/bash
echo "Waiting for docker daemon to start up:"
until docker ps 2>&1| grep STATUS>/dev/null; do sleep 1; done; >/dev/null
docker ps -a | grep sandbox-hdp
if [ $? -eq 0 ]; then
docker start sandbox-hdp
else
docker pull hortonworks/sandbox-hdp-standalone:2.6.4
docker run --name sandbox-hdp --hostname "sandbox-hdp.hortonworks.com" --privileged -d \
-p 9083:9083 \
- Start Docker ./start-sandbox-hdp-standalone_2-6-4.sh
... View more
07-16-2018
11:19 PM
Hi @Gaurang Shah! Did you try to execute beeline with your user? beeline -u 'jdbc:hive2://HS2_SERVER:10000/default' -n gaurang.shah
!sh ls -lh /home/gaurang.shah/ Hope this helps
... View more
04-18-2018
06:40 AM
I am glad the problem is resolved. Both 1) http://nexus-private.hortonworks.com/nexus/content/groups/public/ 2) http://repo.hortonworks.com/content/groups/public/ Will resolve this issue as mentioned in my previous link to refer hortonworks public repo. Please accept the answer
... View more
04-11-2018
01:06 PM
@bkosaraju HDFS file has UTF-8 encoding and Netezza table also has UTF-8 encoding. the problem is with NFC (normalization)
... View more
03-19-2018
06:16 PM
The issue was with the /n character at the end of the file. It works perfectly without issue on Netezza however it creates an issue on SQL Server following command to create new password file resolved the issue. tr -d '\n' < sqlserver_password.pass > sqlserver.pass
... View more
03-07-2018
02:30 PM
You may want to look at this answer.
... View more
03-06-2018
03:58 AM
1 Kudo
@Constantin Stanca could you please explain the approach in detail.
... View more