Questions tagged [dremio]
64 questions
0
votes
1 answer
How to add hours in a TO_TIMESTAMP function?
New to SQL
I am using the TO_TIMESTAMP feature to change a column to datetime. Is there anyway I can apply a subtraction of 5 hours into the TO_TIMESTAMP function that would apply it everytime the SQL is ran?
How I am using it currently:
select…
RustyShackleford
- 3,462
- 9
- 40
- 81
-1
votes
1 answer
Adding Table column and column descriptions for a VDS in Dremio Wiki
I'm trying to add a table (VDS) column and description in Dremio WIKI page. In Edit mode of wiki, no issues, it shows Column and Descriptions as (tow column) array. In display mode, it looses the array form and shows appended column and…
-1
votes
1 answer
Dremio date conversation
How to convert date field "Dec 1 2018 6:38PM" to dd-mm-yyyy (01-12-2018)` in Dremio?
user11043921
- 11
- 1
- 1
-2
votes
2 answers
Get all distinct values from column1 in case of 2 similar rows, get the one with column2 not null
I have a large table as dataset. If there are 2 similar rows with same date and id then how do I get the row for which another column value is not null?
SELECT *, row_number()
over (partition by id order by date desc) rowNumber
FROM table where…
MKM
- 1
- 2