Re: HELP with Pandas into zeppelin

honza_nguyen1 · ‎11-24-2017

My version is 0.7.0.2.6 (screenshot). I have changed the path, restart the notebook but it doesnt work..:/ What should I do, I need pandas to plotting..:/

honza_nguyen1 · ‎11-24-2017

@Paul Hernandez The location was by default, I dont know. I have another question, I am trying to create python interpret, but I cant edit interpreter group. I am following your guide. How could I create it?

honza_nguyen1 · ‎11-24-2017

Hi, @Paul Hernandez, where could I find "path-to-your-python/bin/python". When type which anaconda it gave me back /root/yes/bin/anaconda. So should I put this as a path? That means: export PYTHONPATH="/root/yes/bin/anaconda/bin:/usr/hdp/current/spark-client/python/lib/py4j-0.8.2.1-src.zip" export SPARK_YARN_USER_ENV="PYTHONPATH=${PYTHONPATH}" export PYSPARK_DRIVER_PYTHON="/root/yes/bin/anaconda." export PYSPARK_PYTHON="/root/yes/bin/anaconda" export PYLIB="/var/opt/teradata/anaconda3/envs/py35/lib"¨ - here I cant find this folder.. Thank you for helping me.

honza_nguyen1 · ‎11-24-2017

Hi @Aditya Sirna, I cant find PYSPARK_DRIVER_PYTHON in the Advanced zeppelin-env ->zeppelin_env_content . Check the configuration in the attachment. So shoud I add a new line into this configuration file? export PYSPARK_DRIVER_PYTHON= /root/yes/anaconda and change zeppelin.pyspark.python = /root/yes/anaconda. Like this? e this?

honza_nguyen1 · ‎11-23-2017

Hello guys, I still have this problem. I have installed pandas into system. After installation I have restart the zeppelin notebook. But still It shows me the messae: no module named pandas. Someone gave me advice, that I should verify spark interpreter settings config "zeppelin.pyspark.python". I tried put there anaconda instead of python, but it didnt work. I tried put the location of anacoda /root/yes/bin/anaconda too but it didnt work. So what sould I put there? Does anybody know how to solve this problem? Or how could I import pandas module insto Hortonworks in the easiest way?

honza_nguyen1 · ‎11-19-2017

So, should I put the location of anacoda in the config? I tried put there anaconda instead of python, but it didnt work. I tried put the location of anacoda /root/yes/bin/anaconda too but it didnt work. So what sould I put there?

honza_nguyen1 · ‎11-15-2017

hello guys, I have problem with installing pandas module. I have already installed it with anacoda and pip install pandas as you can see in screenshot. I have already restared zeppelin too. When I execute the my script, it still shows up that there is no module name pandas. Could anyone help me with this? Thanks

honza_nguyen1 · ‎11-11-2017

Using the the sandbox 2.6 solved this problem....thank you @Danilo Perez

honza_nguyen1 · ‎11-11-2017

Thank you.... According to your posted links and this link https://community.hortonworks.com/questions/67677/javalangoutofmemoryerror-java-heap-space-error.html I solved the problem. Thank you.

honza_nguyen1 · ‎11-10-2017

I set it up....but i dont know, why my easy query select count (*) from cdr use 90% of Yarn ..? take a look at screenshots..

honza_nguyen1 · ‎11-10-2017

No I set the value to 900MB and it is still not working...

honza_nguyen1 · ‎11-10-2017

oh sorry...this will be better. Where could I foung info abou "hive.tez.container.size" value ? Thanks

honza_nguyen1 · ‎11-10-2017

Hi guys, I am trying to execute a command from zeppelin. I use the sandbox 2.6 and my VM has 16GB ram. I dont know why it is out of memmory. Could anybody help me?

honza_nguyen1 · ‎11-07-2017

could you give me your skype or email conctact? I would like to ask you for some more information....I dont know if I can send a meessage here.

honza_nguyen1 · ‎11-07-2017

Perfect it works! Thank you a lot.

honza_nguyen1 · ‎11-07-2017

Hello guys, I am working with Hortonworks sandbox 2.6 at the first time. I am trying to copy data from local machine to HDFS. First I tried the command su hdfs but got a message > user hdfs does not exist. Second i would like to run HIVE in command line but the command hive is not working (hive:command not found). Could you guys help me with these issues? Thank you

honza_nguyen1 · ‎11-06-2017

Hello @Danilo Perez, thank you for quick reply. May I ask you for more information? I do not exactly know what is the handsontable. It will replace zeppellin or it runs on zeppelin? So now I should upgrade my zeppelin to the version 0.7.0 or should I use the sandbox 2.6 which already has the newest version of zeppelin. Accoring to the gif, In my screen show above I dont have any button for changing the output type. I have used the command %hive select * from my table. How could I change the output type? Regards , Hello @Danilo Perez, thank you for your reply. Could I ask you for more information? According to the gif - a I do not have any button to change the type of output. For example my screenshot is the result of using command %hive select * from mytable. So I should upgrade zeppelin to the version 0.7.0? I have took a look at the handsontable. But I dont know what it actualy is. Hansotable will replace zeppelin or it works on it? Could you explain it to me please? Thank you very much!

honza_nguyen1 · ‎11-05-2017

Hello guys, is there any way how to get the output numbers without commas? I am using hive interpret. In the screenshot the last columm contains salaries. Could I get this salaries like this 70000? Thank you guys.

Online	Offline
Last Visited	‎11-24-2017 11:14 AM

Date Registered	‎11-05-2017 09:53 PM
Last Visited	‎11-24-2017 11:14 AM
Total Messages Posted	20

Re: HELP with Pandas into zeppelin

Re: HELP with Pandas into zeppelin

Re: HELP with Pandas into zeppelin

Re: HELP with Pandas into zeppelin

HELP with Pandas into zeppelin

Re: No module named pandas

No module named pandas

Re: Zeppelin numbers without commas

Re: Tez out of memory?

Re: Tez out of memory?

Re: Tez out of memory?

Re: Tez out of memory?

Tez out of memory?

Re: hdfs user and commands

Re: hdfs user and commands

hdfs user and commands

Re: Zeppelin numbers without commas

Zeppelin numbers without commas