- 2454 Views
- 3 replies
- 0 kudos
I notice it is very easily to get visualization from sql language inside Databricks. Say you run a SQL query which gives you a table, and you can easily use that table to do its visualization in terms of plots.
How about in Python language when we ...
- 2454 Views
- 3 replies
- 0 kudos
Latest Reply
Yes! You can visualize a Python DataFrame in Databricks easily using: display(df)This works like SQL visualizations, offering built-in charts. For more customization, Matplotlib, Seaborn, or Plotly can be used. Would love to see even more native sup...
2 More Replies
- 12993 Views
- 5 replies
- 3 kudos
While using cx_oracle python library, it returns the below error:
error message: Cannot locate a 64-bit Oracle Client library: "libclntsh.so: cannot open shared object file: No such file or directory
The cx_oracle library is dependent on native...
- 12993 Views
- 5 replies
- 3 kudos
Latest Reply
Hi @AshvinManoj I used your script and still get same error. sudo echo 'LD_LIBRARY_PATH="/dbfs/databricks/instantclient_23_6"' >> /databricks/spark/conf/spark-env.shsudo echo 'ORACLE_HOME="/dbfs/databricks/instantclient_23_6"' >> /databricks/spark...
4 More Replies
- 5530 Views
- 5 replies
- 5 kudos
The client receives data from a third party as weekly "datadumps" of a MySQL database copied into an Azure Blob Storage account container (I suspect this is done manually, I also suspect the changes between the approx 7GB files are very small). I nee...
- 5530 Views
- 5 replies
- 5 kudos
Latest Reply
Hi @Sylvia VB Thank you for posting your question in our community! We are happy to assist you.To help us provide you with the most accurate information, could you please take a moment to review the responses and select the one that best answers you...
4 More Replies
- 1933 Views
- 1 replies
- 0 kudos
I have an issue to install and use kneed python libary.
https://pypi.org/project/kneed/
I can install it and check it from log.
[Install command]
%sh
pip install kneed
[log]
Installing collected packages: kneed
Successfully installed kneed-0...
- 1933 Views
- 1 replies
- 0 kudos
Latest Reply
The kneed library has a dependency and we need to install them as well in order to work:numpy==1.18scipy==1.1.0scikit-learn==0.21.3Once we install the above libraries using GUI, we can run the below command to check the installed library with the cor...
- 3367 Views
- 1 replies
- 0 kudos
while using the sqlalchemy, unable to connect with sql server from databricks:
user='user@host.mysql.database.azure.com'
password='P@test'
host="host.mysql.database.azure.com"
database = "db"
connect_args={'ssl':{'fake_flag_to_enable_tls': True}}
c...
- 3367 Views
- 1 replies
- 0 kudos
Latest Reply
We can use urllib.parse to handle special characters. Here is an example:import urllib.parse
user='user@host.mysql.database.azure.com'
password=urllib.parse.quote_plus("P@test")
host="host.mysql.database.azure.com"
database = "db"
connect_args={'...
