PaprikaCayenne PaprikaCayenne
PaprikaCayenne
/ date_add_week
Created
June 2, 2020 15:59
[Date Add Week and Month] this should add week and month name #tableau #date
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| DATEADD( | |
| 'year', | |
| DATEDIFF('year',[Impression Timestamp],TODAY()), | |
| [Impression Timestamp] | |
| ) |
PaprikaCayenne
/ nestedTables.sql
Created
May 29, 2020 00:41
[Match ID to ID] Example to show how to match id nested in other tables #mySQL
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| UPDATE db_ALSAC_AAM_Traits_Match_Tables.tbl_AAM_traits_Union_Overlap Ovr | |
| JOIN db_ALSAC_AAM_Traits_Match_Tables.tbl_Data_Source_Names Dsn ON Dsn.dataSourceId = Ovr.data_source_id | |
| JOIN db_ALSAC_AAM_Traits_Match_Tables.tbl_Data_Source_Group_id Dsg ON Dsg.id_data_source_group = Dsn.id_data_source_group | |
| SET Ovr.Data_Source_Group_Name = Dsg.data_source_group_name | |
| WHERE Ovr.data_source_id = Dsn.dataSourceId; | |
| https://dba.stackexchange.com/questions/50981/mysql-update-query-with-subquery |
PaprikaCayenne
/ amobee_getting_reach.sql
Created
May 28, 2020 16:57
[Amobee getting Reach] #mySQL #Amobee #Abbott
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT COUNT(DISTINCT user_id) AS 'Unique Count', COUNT (*) AS 'Total Impressions', COUNT(*)/COUNT(DISTINCT user_id ) AS 'Frequency' FROM db_abbott_amobee_union.tbl_amobee_impressions_tableau; |
PaprikaCayenne
/ AE2 Error
Created
October 8, 2019 21:46
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [16:37:57] [Server thread/FATAL] [minecraft/MinecraftServer]: Error executing task | |
| java.util.concurrent.ExecutionException: java.lang.ClassCastException: appeng.util.item.AEItemStack cannot be cast to appeng.api.storage.data.IAEFluidStack | |
| at java.util.concurrent.FutureTask.report(Unknown Source) ~[?:1.8.0_221] | |
| at java.util.concurrent.FutureTask.get(Unknown Source) ~[?:1.8.0_221] | |
| at net.minecraft.util.Util.func_181617_a(SourceFile:47) [h.class:?] | |
| at net.minecraft.server.MinecraftServer.func_71190_q(MinecraftServer.java:723) [MinecraftServer.class:?] | |
| at net.minecraft.server.dedicated.DedicatedServer.func_71190_q(DedicatedServer.java:397) [nz.class:?] | |
| at net.minecraft.server.MinecraftServer.func_71217_p(MinecraftServer.java:668) [MinecraftServer.class:?] | |
| at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:526) [MinecraftServer.class:?] | |
| at java.lang.Thread.run(Unknown Source) [?:1.8.0_221] |