Alan
- Total activity 389
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 46
- Subscriptions 166
Comments
Recent activity by Alan-
Hi Arturo, Yes JDBC should be working for IMPALA sources. Please start a new thread if you have further questions!
-
Hi Greg, After some further research, I found the key in which the fix was merged - this is indeed fixed in 7.2.6 and higher on the 7.2.x track, and is fixed in all 7.4 releases. Apologies for any ...
-
Hi Greg, Can you tell me more about the data source? If you duplicate the sheet where the data is coming from and reference the duplicate in the REPLACE - does it help at all? I've done some diggin...
-
Hi Greg, Is this only happening with this one column? Did it work replacing INCORPORATED with INC? I tested a similar query: SELECT REPLACE(words,'LTD','LTD.') FROM words_csv2 I don't have a 7.2.3...
-
Hi Greg, Sorry, went off on a wrong direction! I got this working: SELECT REPLACE(column, 'INCORPORATED', 'INC') FROM sheet
-
Hi Greg, The REPLACE function requires the following: 1st argument: The string in question you are working with. 2nd argument: The starting position within the string where the replace should begin...
-
Hi Satwinder, The format of the JDBC connection string should be as follows: jdbc:hive2://<zookeeper quorum>/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2 Note, if your namespace i...
-
Hi Tiago, This capability will not be implemented within Datameer for infographics. However I believe you're looking to do Data Exploration, which we have Visual Explorer for now. https://documenta...
-
Hi Ishfaq, If the values are blank, you can create a new column using the IF function to remove the blank values. If the values are null, you can use the DENULLIFY function to remove the nulls. Let...
-
Hi Mary, First, do your sanitation steps, removing stop words, converting to lower, etc. Then follow these steps:1. On a new sheet in column one simply add your sanitized column.2. On the same shee...