Tutorial by Examples: for

hadoop fs -setfacl

It's possible to have your own custom code styles, share them with other team members and use a shortcut to auto format the code in a file. To create your own custom code style, go to: Preferences -> Editor -> Code Style There are some general code style settings here. You can also select ...

We have a Student table with SubjectId. Here the requirement is to concatenate based on subjectId. All SQL Server versions create table #yourstudent (subjectid int, studentname varchar(10)) insert into #yourstudent (subjectid, studentname) values ( 1 ,'Mary' ) ,( 1 ,'John' ...

In case of SQL Server 2017 or vnext we can use in-built STRING_AGG for this aggregation. For same student table, create table #yourstudent (subjectid int, studentname varchar(10)) insert into #yourstudent (subjectid, studentname) values ( 1 ,'Mary' ) ,( 1 ,'John' ) ,( 1 ...

apcu_cache_info provides information about the store and its entries: print_r(apcu_cache_info()); Note that invoking apcu_cache_info() without limit will return the complete data currently stored. To only get the meta data, use apcu_cache_info(true). To get information about certain cache ...

When creating a std::unique_lock, there are three different locking strategies to choose from: std::try_to_lock, std::defer_lock and std::adopt_lock std::try_to_lock allows for trying a lock without blocking: { std::atomic_int temp {0}; std::mutex _mutex; std::thread t( [&...

import {Http} from '@angular/http'; @Injectable() export class StudentService{ constructor(public http: Http){} getAllStudents(): Observable<Students[]>{ return this.http.get('assets/students.json') .map(res => res.json().data) } } notice ...

Log into a Google Account and click New > More > Google Forms. Build the form fields required using the editor. If the form was built with an account that is part of an organisation then click on the cog and unselect the option that only members can complete the form. Set the form to save t...

This is done by adding a button, dialog box and iframe as explained below. The examples below use MDL for look and feel because it is used by Google forms and so it makes the additional elements look fairly seamless. Dialog boxes may require a polyfill if you plan to support older browsers.

Add a new function called showGoogleForm and adapt the follow code to suit. Note for simplicity this example does not contain any error checking which should be added in a production environment. The url should look something like this: https://docs.google.com/forms/.../?usp=pp_url&entry.17391...

Syntax: FormatConditions.Add(Type, Operator, Formula1, Formula2) Parameters: NameRequired / OptionalData TypeTypeRequiredXlFormatConditionTypeOperatorOptionalVariantFormula1OptionalVariantFormula2OptionalVariant XlFormatConditionType enumaration: NameDescriptionxlAboveAverageConditionAbove av...

Remove all conditional format in range: Range("A1:A10").FormatConditions.Delete Remove all conditional format in worksheet: Cells.FormatConditions.Delete

Highlighting Duplicate Values With Range("E1:E100").FormatConditions.AddUniqueValues .DupeUnique = xlDuplicate With .Font .Bold = True .ColorIndex = 3 End With End With Highlighting Unique Values With Range("E1:E100").FormatConditions.AddUniqueVa...

Highlighting Top 5 Values With Range("E1:E100").FormatConditions.AddTop10 .TopBottom = xlTop10Top .Rank = 5 .Percent = False With .Font .Bold = True .ColorIndex = 3 End With End With

With Range("E1:E100").FormatConditions.AddAboveAverage .AboveBelow = xlAboveAverage With .Font .Bold = True .ColorIndex = 3 End With End With Operators: NameDescriptionXlAboveAverageAbove averageXlAboveStdDevAbove standard deviationXlBelowAverageBelow ...

Range("a1:a10").FormatConditions.AddIconSetCondition With Selection.FormatConditions(1) .ReverseOrder = False .ShowIconOnly = False .IconSet = ActiveWorkbook.IconSets(xl3Arrows) End With With Selection.FormatConditions(1).IconCriteria(2) .Type = xlConditionValueP...

Basically to apply a theme for SearchView extracted as app:actionViewClass from the menu.xml, we need understand that it depends completely on the style applied to the underlying Toolbar. To achieve themeing the Toolbar apply the following steps. Create a style in the styles.xml <style name=&qu...

Processlist This will show all active & sleeping queries in that order then by how long. SELECT * FROM information_schema.PROCESSLIST ORDER BY INFO DESC, TIME DESC; This is a bit more detail on time-frames as it is in seconds by default SELECT ID, USER, HOST, DB, COMMAND, TIME as time_second...

A for loop iterate through items in an array program ArrayLoop; {$APPTYPE CONSOLE} const a : array[1..3] of real = ( 1.1, 2.2, 3.3 ); var f : real; begin for f in a do WriteLn( f ); end. Output: 1,1 2,2 3,3

When a remote session is created via the New-PSsession cmdlet, the PSSession persists until the current PowerShell session ends. Meaning that, by default, the PSSession and all associated resources will continue to be used until the current PowerShell session ends. Multiple active PSSessions can b...