Alan Mark
- Total activity 389
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 45
- Subscriptions 167
Activity overview
Latest activity by Alan Mark-
Alan Mark commented,
Hi Fenghua, You can find all our supported SQL functionality here: Using SQL Sheets: SQL Editor Features The error message is correct. The SQL editor does n't support the CUBE, ROLLUP, or GROUPSET...
-
Alan Mark commented,
Hi Mario, Our AVERAGE function provides the average of each row for the columns specified as arguments. For example, if you have three columns and AVERAGE them as follows: AVERAGE(Column1;Column2;C...
-
Alan Mark commented,
Hi Elwyn, Thank you for supplying this collateral. We'll perform some testing an let you know what the outcome is. Alan
-
Alan Mark commented,
Hi Elwyn, Datameer DATE fields store data as Epoch time, the number of milliseconds since UNIX Epoch. I suspect we may be encountering some incorrect rounding based on the internal representation....
-
Alan Mark commented,
Hi Dave, Thanks for reaching out. Unfortunately Datameer X does not support in line comments within the formula builder. However, each column does have a Description text area within the Inspecto...
-
Alan Mark created an article,
com.amazonaws.SdkClientException: Unable to execute HTTP request: Timeout waiting for connection from pool
SymptomAttempting to run a job that leverages S3 storage, the following error is thrown in the job.log UnrecoverableException: java.io.InterruptedIOException: getFileStatus on s3://bucketname/Datam...
-
Alan Mark commented,
On the Configure step, could you try raising the number of sample records to 10,000 to see if increasing the sample will help catch a column with data? If this doesn't work, I'll need to do some te...
-
Alan Mark commented,
Hi Elwyn, Does the column appear in the Define Fields step? Or is it missing entirely? You might just need to click the 'include' checkbox on the column there. Alan
-
Alan Mark commented,
Hi Elwyn, You can work around this within the product by expanding the Advanced section of the Data Details step while creating the Import job. There, you can increase the number of records read f...
-
Alan Mark commented,
Hi Ganesh, Please refer to the documentation on our TIMESTAMPDIFF function. It takes arguments for start date, end date, and date interval. You can specify Months as the interval, and then specify...