Tag » Csv

Export Power BI Desktop data to CSV Files

A few months ago I published a PowerShell module called PowerBIETL that allows you to export all your Power BI Desktop file data to a SQL Server database: 65 altre parole

PowerShell

Writing a CSV file in batches

CsvHelper is a great package for reading and writing CSV files. Sometimes you want to write a CSV file in batches, for example when you export a large database table to a CSV file. 86 altre parole

.NET

Edition 3#

Diagnosing a Linux-Only Unit Test Failure (Article)

Jon Skeet

” This is an odd one. I’m currently working on Cloud Firestore support for C#, and I’ve introduced a  231 altre parole

October 2017

Using Node-Red to graph scale data

Having used Node-Red briefly about two years ago, i decided to load it again onto the Raspberry Pi which listens for my BS440 scale. Just to dig into Node-Red and see where it got. 353 altre parole

BS440

Discover the recently added import options for RoboForm 8

RoboForm now supports data import from 18 different browsers and password managers, as well as CSV!

If you’re not currently a RoboForm user, it’s more than likely you have a list of passwords stored elsewhere. 228 altre parole

Passwords

Reading nested parquet file in Scala and exporting to CSV

Recently we were working on a problem where the parquet compressed file had lots of nested tables and some of the tables had columns with array type and our objective was to read it and save it to CSV. 337 altre parole

Scala

SAVE HIVE QUERY OUTPUT TO A FILE USING BEELINE

beeline -u 'jdbc:hive2://my.example.com:7676/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2-hive2' --outputformat=csv2 --showHeader=true -e "select * from database.hive_table" > HW_data.csv

Additional Parameters :

   --showHeader=       show column names in query results
   --headerInterval=ROWS;          the interval between which heades are displayed
   --fastConnect=      skip building table/column list for tab-completion
   --autoCommit=       enable/disable automatic transaction commit
   --verbose=          show verbose error messages and debug info
   --showWarnings=     display connection warnings
   --showNestedErrs=   display nested errors
   --numberFormat=        format numbers using DecimalFormat pattern
   --force=            continue running script even after errors
   --maxWidth=MAXWIDTH             the maximum width of the terminal
   --maxColumnWidth=MAXCOLWIDTH    the maximum width to use when displaying columns
   --silent=           be more silent
   --autosave=         automatically save preferences
   --outputformat=  format mode for result display
                                   Note that csv, and tsv are deprecated - use csv2, tsv2 instead 26 altre parole
Hive