I'm using Vertica on the back end but most of the syntax is identical and this is the best forum I've found for it.charindex is t-sql I believe. I'm sure this is not t-sqlWhich RDBMS you're working with?This is a MS SQL SERver forum so you may be better off using relevent forums if you're not using SQL Server-SQL Server MVP In my where statement I'm including:find(upper(place_name),'STARBUCK')>0and getting the following error in DBVisualizer (connecting to Vertica): ERROR: function find(varchar, "unknown") does not exist, or permission is denied for find(varchar, "unknown")I get the same error trying to apply the same constraint using the charindex function instead. I have messy place name data in a column called place_name and I only want to extract Starbucks. The DriverManager will try to load as many drivers as it can find and then for any given connection request, it will ask each driver in turn to try to connect to the target URL. Ask question asked 3 years, 3 months ago. We've got lots of great SQL ServerĮxperts to answer whatever question you can come up with. DBeaver uses the Vertica JDBC driver to connect to Vertica.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |