About Simon_Ye

Simon_Ye · 05-19-2021

I manually add some info into logs by api.log in python3 operator, but I want the log to only work on the development system, but not in the production system. How can implement this by python script in Data intelligence. Regards, Simon

Simon_Ye · 05-19-2021

I have graph A and graph B, and I don't want them executed in parallel, so I add a checker in graph A to check if graph B is running now when I trigger graph A.

Simon_Ye

what's the data type of column "clustd", what's the target data type? if you want to convert binary to string, try function BINTOSTR

Simon_Ye

try the Windows function LAG Function (Window)

Simon_Ye · 06-19-2024

Suppose you have a datetime column "UPDATED_ON", you can use the function "strftime" to convert it to a string with a specific format:1. import the "datetime" class from "datetime" module from datetime import datetime2. use "strftime" to convert ...

Simon_Ye · 06-17-2024

Try this: TO_NVARCHAR(CURRENT_DATE,'YYYYMM')

Simon_Ye · 05-24-2024

Hi,First, the issue is caused by some invalid datatime value, you just need to check the related columns. it's not very convenient to debug the Python script in Datashpere, you can try to debug it in other applications, like Jupyter Notebook, with so...

User Statistics

User Activity

How can we get current system infomation by python script.

How to check if a specific graph is running in a graph

Re: Need Blob to text conversion in Data Sphere

Re: Repeat value from previous cell when it is blank per...

Re: how to change data type from time to string from a ta...

Re: Current_Data() in YYYYMM format in Datasphere View

Re: Invalid datetime value when using Python Script in Da...