Categories
Development

Cloudwatch datasource not working after grafana upgrade

I was working with Grafana 5.x version and elasticsearch 6.4 version. Due to some requirements we need to upgrade Elasticsearch to its 7.0+ version so we did that but the Grafana was still using 5.x version of Elasticsearch Datasource. At Grafana Latest version was not available so we also upgraded Grafana too which cause other […]

Categories
Development

Handling Excel merged cells, Pivoting in Python/Spark

I am working with the following data set (sample): I have been trying to convert this into the following schema: Name Currency Date Net – Current Time – Current I have tried reading the file in both pandas using read_excel and read_csv, as well as in dataframe but unable to change the data into the […]

Categories
Angular Development

How can i use gRPC in angular 8

I m first-time implement gRPC Is there any way to use gRPC in angular 8. How can we implement gRPC how to use google protocol buffers within an angular 7/8 project

Categories
Development

Update texture of mesh using ThreeJS & Dat.Gui

I would like the texture of my Mesh to update when clicked on function. When you click on the ‘UpdateMateria’ function i’d like the mesh to dispose its current texture and add a new one. Animation Loop startAnimationLoop = () => { const tableBoard = this.scene.getObjectByName(‘tableSurface’); tableBoard.material.map = this.updateMateria; this.renderer.render(this.scene, this.camera); this.requestID = window.requestAnimationFrame(this.startAnimationLoop); }; […]

Categories
Development

Why does ffmpeg output have to be encoded entirely before it can be played?

I have an MVC C# application (sort of) that calls an api to get a FileStreamResult from an mp4. At the moment the mp4 is your standard h.264 encoded file and we just create a FileStream of the mp4 file and return a new FileStreamResult of that FileStream. Works fine. The mp4 is immediately available […]

Categories
Development

OCaml corebuild cannot link to Core.Std

My problem is similar to this, however, in my case .ocamlinit is set. Here is my ocaml version. mymac:Desktop myusr$ ocaml –version The OCaml toplevel, version 4.08.1 Here is my opam version. mymac:Desktop myusr$ opam –version 2.0.5 Here is my opam switch. mymac:Desktop myusr$ opam switch # switch compiler description → 4.08.1 ocaml-base-compiler.4.08.1 4.08.1 default […]

Categories
Development

For each Loop Deployment issue

I have a package that need to use for each loop. I have a staging table that has all the months, I want to loop through every month (Jan, Feb, Mar, …, Dec) and load the data into the real table. So I have use execute SQL task to query all the column names of […]

Categories
Development

SSIS Excel to SQL Server – Long Data on Column Failure

I have an SSIS package set up to use a ForEach File loop. This loop should pick up all *.xlsx files and transfer them to the SQL Server. The trouble I am having is with a few of the columns where there may anything from no text to a thousand characters. When I set up […]

Categories
Development

Copy Data of All Files in a Folder and Make a Master Sheet in Excel For Analysis

Hy! Problem Description: I have multiple workbooks in my Data Folder. I have written a Macro that is copying data from all the files But it skipping the first Sheet Tab data in every workbook and start copy data from 2nd Sheet Tab. I want you to review my code and guide me where I […]

Categories
Development

A table with 80% text data type and 140 columns taking much time in table scan which slow down the query

I have a table with 100 columns where 80% column is nvarchar(max) and there is no way to change this data type cause i am getting this data from MySQL text type column. This table contains almost 30lacs records, so when I am selecting all the columns it takes too much time to show recordset. […]