Formula in db extracting distinct values
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
I'm trying to pull distinct values from a table in HIVE . First, I made the connection with 'connect In-DB' (no problems here), then I used 'formula in db' to pull distinct values for name.
I use ---- SELECT DISTINCT name FROM x_t1, but it seems to giving me an error. What am I doing wrong? x_t1 table is under a different folder if it makes any difference.
Thanks
Solved! Go to Solution.
- Labels:
- Database Connection
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @fomenter,
I'd suggest entering the query directly into the connect in-db query box rather than the in-db formula tool.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
Trying to accomplish the same thing. However, I want to apply the "select distinct" halfway through my workflow, not at the begging. I'm trying to use the In-DB Filter tool but am also pulling an error. Any help on the syntax?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @dsemitekol
Have you thought about using the summarize tool at that point (and grouping by the dimension you want the distinct values for)? If you're able to give some more info about the result you're trying to achieve I can probably advise further.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
