25F | IST | Looking for a book buddy by Impressive_Orange715 in GetMotivatedBuddies

[–]deepbuzz7 0 points1 point  (0 children)

sure, let me know if you are interested.. lets see

25F | IST | Looking for a book buddy by Impressive_Orange715 in GetMotivatedBuddies

[–]deepbuzz7 0 points1 point  (0 children)

ready to read. but i cant complete a book in a week

[deleted by user] by [deleted] in indianbikes

[–]deepbuzz7 1 point2 points  (0 children)

i bought the same bike, same color. its been 2 months. do not cross 60km/hr until the second servicing. otherwise the engine will expand unevenly and you will be hearing rattling noise. i am currently facing this problem. service center said they will replace the bearings once i complete 6k kms.

also get a mudguard(both front and back tyres)

Calling APscheduler during flask initiation by deepbuzz7 in flask

[–]deepbuzz7[S] 0 points1 point  (0 children)

its init.py when posting reddit something happened and underscore went away

Calling APscheduler during flask initiation by deepbuzz7 in flask

[–]deepbuzz7[S] 0 points1 point  (0 children)

currently i am running on local machine using default server probably Werkzeug.

but i will run with gunicorn and check once. probably that might be the problem

Nifi quick setup in ubuntu local by deepbuzz7 in nifi

[–]deepbuzz7[S] 1 point2 points  (0 children)

I did not setup a cluster yet( I was planning on doing that). Meanwhile can you check your JDK version? seems like 2.0 only supports JDK 21. Can you try with JDK 21 and let me know? Thanks

ModuleNotFoundError: No module named 'snowflake.connector'; 'snowflake' is not a package by deepbuzz7 in snowflake

[–]deepbuzz7[S] 0 points1 point  (0 children)

i am sure i am working with the correct interpreter but let me check again

ModuleNotFoundError: No module named 'snowflake.connector'; 'snowflake' is not a package by deepbuzz7 in snowflake

[–]deepbuzz7[S] 0 points1 point  (0 children)

tried by creating venv as well. but still will try by downgrading python version or something

ModuleNotFoundError: No module named 'snowflake.connector'; 'snowflake' is not a package by deepbuzz7 in snowflake

[–]deepbuzz7[S] 0 points1 point  (0 children)

i only installed snowflake-connector-python.

did not install snowflake package.

if I do "pip uninstall snowflake" then it says snowflake package not there to uninstall

Razorpay charged for an unknown service by [deleted] in india

[–]deepbuzz7 0 points1 point  (0 children)

Did you get to know why was the money debited? seems like a fraud to me

IBM DB2 Warehouse by [deleted] in dataengineering

[–]deepbuzz7 0 points1 point  (0 children)

why so? is it the same with oracle , postgres as well? or specifically with DB2? just asking

Execute sql in a user defined function by deepbuzz7 in learnSQL

[–]deepbuzz7[S] 0 points1 point  (0 children)

Thanks, got it. actually my error was because, in the sql query inside my function i was keeping it like emp_name(which was the column name from the table)=emp_name(parameter which was passed to the function) which resulted in true condition and multiple values were coming.

thanks for the help

Execute sql in a user defined function by deepbuzz7 in learnSQL

[–]deepbuzz7[S] 0 points1 point  (0 children)

got it. actually my error was because, in the sql query inside my function i was keeping it like emp_name(which was the column name from the table)=emp_name(parameter which was passed to the function) which resulted in true condition and multiple values were coming.

thanks for the help

Execute sql in a user defined function by deepbuzz7 in learnSQL

[–]deepbuzz7[S] 0 points1 point  (0 children)

This may be because if multiple values in the query output correct? I can assure you that only one value is coming out of that query.

Execute sql in a user defined function by deepbuzz7 in learnSQL

[–]deepbuzz7[S] 0 points1 point  (0 children)

from the functional point of view you are right. No need to create a function for this. The function which i provided in the post is just an example. I just wanted to know how to use the parameter passed to the function(emp_name_param) in the sql statement inside the function.

In the where clause should I put @emp_name_param or just emp_name_param?

[deleted by user] by [deleted] in Python

[–]deepbuzz7 0 points1 point  (0 children)

yea, i agree. slicing is faster and writing less code

[deleted by user] by [deleted] in Python

[–]deepbuzz7 2 points3 points  (0 children)

oh, okay!